I recently changed from windows 2000 to win xp sp2 eval and I use a web /database server to do web development.

I am using a dsl connection to connect to internet.

The problem I am facing is that whenever I enable the network (dsl connection) everything that has to do with local addresses like 127.0.0.l or 192.168.1.2 or localhost becomes very slow. Mysql- webserver everything becomes slower. If I disable the network everything including local web server returns requests very fast. But then I cannot access internet at the same time I work.

I didn t face any problem on windows 2000 eval.

CREATE TABLE users (
user_id INT UNSIGNED NOT NULL AUTO_INCREMENT-
first_name VARCHAR(20) NOT NULL-
last_name VARCHAR(40) NOT NULL-
email VARCHAR(80) NOT NULL-
pass CHAR(40) NOT NULL-
user_level TINYINT(1) UNSIGNED NOT NULL DEFAULT 0-
active CHAR(32)-
registration_date DATETIME NOT NULL-
PRIMARY KEY (user_id)-
UNIQUE KEY (email)-
INDEX login (email- pass)
);

what does INDEX login(email- pass) mean?

how can you have two indexes and login is not a row in the table? how would i go about creating this table in mysql admin? or how would i create the code and run it on the server?

thanks

ok- simple scenario... There is one input for a name- when you enter your name and submit- it is entered into a table as such...
+--+-----------+
| id | name |
+--+-----------+
| 1 | first last |
+--+-----------+

so- I have a big column (with unique ids) with lots of names. I want to make it so that- if you try to enter a name- it searches the database for duplicates. So- if you have already entered that name- it doesn t allow you to enter it again.

How can I search the table column for names against a posted name? and- if a duplicate is found- give the user an error and prevent their value from entering into the table?
also- how can I check if the query has returned something within the PHP?
what I have now is

$sql = SELECT * FROM `scores` WHERE student = \ .$name. \ LIMIT 0- 1 ;

how do I use the sql s return?
the code I ended up using was as follows.

$sql = SELECT * FROM `scores` WHERE student = \ .$name. \ LIMIT 0- 1 ;
$result = mysql_query($sql) ;
$row = mysql_fetch_row($result) ;

if ($row[1] == $name) {
echo name has been entered already ;
}

I may set up some editable Acrobat form documents that are filled out by up to several hundred people to collect some data about them. I m wondering if there are any software packages out there that will extract data from the fields in these hundreds of Acrobat forms and either write the data to a single file or write the data diretly to a MySQL database?

I m creating a database that has a Users table- and two of the columns in the user table are First_name and Last_name. I want to make these columns sort of "semi-unique"; in other words- there can be two people with the same first name- or two people with the same last name- but there can t be someone with the same first name AND the same last name. Does anyone know a way to do this?

Please help me to check the php file online -i dont have mysql server -apache -and or Linux Let mew know is there any way to do through online I am using win XP Prof. sp2