Where Am I Going Wrong This Time? Cant enter data into database

[mrdee 1]

Hi,
on my local machine (with Apache 2.0, PHP 5.2.4 and MySQL 5.0) I come across weird things.
I have successfully made a table, but when I try to enter data into it it just will not accept the empty string for the first field (id).
This was the creation line:

$query="CREATE TABLE members (id int(20) auto_increment,first varchar(15) NOT NULL,last varchar(15) NOT NULL,phone varchar(20) NOT NULL,mobile varchar(20) NOT NULL,fax varchar(20) NOT NULL,email varchar(30) NOT NULL,web varchar(30) NOT NULL,PRIMARY KEY (id),UNIQUE id (id),KEY id_2 (id))";

This has created the table no problem.However, when I try to enter something into that table with the following command:

$query = "INSERT INTO members VALUES ('','John','Barnes','01234 567890','00112 334455','01234 567891','johnbarnes@gowansnet.com','http://gowansnet.com;;mysql_query($query);if (@mysql_query ($query)) {print '<p>The data entry was sucessful.</p>';} else {print "<p>Could not add the entry because: <b>" . mysql_error() . "</b>.The query was $query.</p>";}mysql_close();

(and provision to see whether or not it succeeded), I get the following error:

Invalid value in id.
Then, when I try again, it does put data in, but in the wrong table, it either works or doesn't when I have to keep switching the opening tag from <? to <?php and back, ie. it says it has worked with the </ tag, but has not entered any data, then with the <?php tag, it tells me "Access denied", although correct username and password are in the script..
In other words, it seems like the whole system is running quite unstable.
I know I am not being very specific at times, but there is so much going on that i don't know what fault to post anymore.

Would it help if I posted a result from phpinfo()?

Thanks,
(Before I go completely nuts).

[jlhaslip 4]

I just added the Table to a DB and your query ran fine here on the Trap. Then I added an entry using your INSERT and it went in just fine. Repeating the INSERT added the second entry with a different ID number, of course.How did you configure your php and mysql? seperately? or using an installer like XAMPP? or WAMP?Maybe you should un-install the php and mysql then use one of the one-click installers??? might solve this one for you.Don't forget to copy/backup your htdocs folder first.

[mrdee 1]

Since I have been having trouble constantly, I installed everything according to this site:
Installing Apache 2.0 and PHP 5 (And MySQL)

[mrdee 1]

I have simply thrown it all out. (Apache, PHP and MySQL).I came across a wonderful (and free) program today called EasyPHP, which gives you all this too, is less than 8 Mb in size, and at least it works, which means that I will be able to learn PHP/MySQL in peace now, without always having to upload my files for testing them.(And without my hair getting gray, or me having one heart attack after another).

[jlhaslip 4]

Great package.