MySQL table won't create

Code included, problem at bottom.

[Zeteg]

<?
$user="weeee";
$password="rraaawwwrrr";
$database="eeeeeep";
mysql_connect(localhost,$user,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="CREATE TABLE survey (id int(6) NOT NULL auto_increment,age1 varchar(1) NOT NULL,age2 varchar(1) NOT NULL,gender1 varchar(1) NOT NULL,gender2 varchar(1) NOT NULL,cell1 varchar(1) NOT NULL,cell2 varchar(1) NOT NULL,payment1 varchar(1) NOT NULL,payment2 varchar(1) NOT NULL,prepost1 varchar(1) NOT NULL,prepost2 varchar(1) NOT NULL,reason1 varchar(1) NOT NULL,reason2 varchar(1) NOT NULL,reason3 varchar(1) NOT NULL,reason4 varchar(1) NOT NULL,reason5 varchar(1) NOT NULL,reason6 varchar(1) NOT NULL,brand1 varchar(1) NOT NULL,brand2 varchar(1) NOT NULL,brand3 varchar(1) NOT NULL,brand4 varchar(1) NOT NULL,brand5 varchar(1) NOT NULL,brand6 varchar(1) NOT NULL,brand7 varchar(1) NOT NULL,brand8 varchar(1) NOT NULL,brand9 varchar(1) NOT NULL,brand10 varchar(1) NOT NULL,internettime1 varchar(1) NOT NULL,internettime2 varchar(1) NOT NULL,internettime3 varchar(1) NOT NULL,internettime4 varchar(1) NOT NULL,internettime5 varchar(1) NOT NULL,surfing1 varchar(1) NOT NULL,surfing2 varchar(1) NOT NULL,surfing3 varchar(1) NOT NULL,surfing4 varchar(1) NOT NULL,chat1 varchar(1) NOT NULL,chat2 varchar(1) NOT NULL,chat3 varchar(1) NOT NULL,chat4 varchar(1) NOT NULL,internetgames1 varchar(1) NOT NULL,internetgames2 varchar(1) NOT NULL,internetgames3 varchar(1) NOT NULL,internetgames4 varchar(1) NOT NULL,internetgames5 varchar(1) NOT NULL,forums1 varchar(1) NOT NULL,forums2 varchar(1) NOT NULL,forums3 varchar(1) NOT NULL,forums4 varchar(1) NOT NULL,learn1 varchar(1) NOT NULL,learn2 varchar(1) NOT NULL,learn3 varchar(1) NOT NULL,learn4 varchar(1) NOT NULL,music1 varchar(1) NOT NULL,music2 varchar(1) NOT NULL,music3 varchar(1) NOT NULL,music4 varchar(1) NOT NULL,music5 varchar(1) NOT NULL,music6 varchar(1) NOT NULL,online1 varchar(1) NOT NULL,online2 varchar(1) NOT NULL,online3 varchar(1) NOT NULL,online4 varchar(1) NOT NULL,textmessaging1 varchar(1) NOT NULL,textmessaging2 varchar(1) NOT NULL,ringtones1 varchar(1) NOT NULL,ringtones2 varchar(1) NOT NULL,browser1 varchar(1) NOT NULL,browser2 varchar(1) NOT NULL,
games1 varchar(1) NOT NULL,games2 varchar(1) NOT NULL,camera1 varchar(1) NOT NULL,camera2 varchar(1) NOT NULL,downloading1 varchar(1) NOT NULL,downloading2 varchar(1) NOT NULL,digicam1 varchar(1) NOT NULL,digicam2 varchar(1) NOT NULL,PRIMARY KEY (id),UNIQUE id (id),KEY id_2 (id))";
mysql_query($query)
mysql_close();

?>

Parse error: parse error, unexpected T_STRING in /home/zeteg/public_html/zeteg/createdbsurvey.php on line 10

I'm not sure if anyone can tell where the line ends, so kept moving script down to the next line until I found a problem. If my logic is correct, the error is somewhere at the end, starting with PRIMARY KEY. Am I trying to create a database with too many colums? I hope I'm not, since it's kind of vital...

If anyone could help me it'd be greatly appreciated. Thank you.

[dreamcatcher]

Hi Zeteg, welcome to Webmaster World. :)

Is it because you are missing a semi colon at the end of this line:

mysql_query($query)

?

dc

[jd01]

PRIMARY KEY (id),UNIQUE id (id)

Interesting - not something I have ever tried, but you are setting a UNIQUE KEY on a col that is unique by default (PRIMARY KEY) - If it is not the ; this may be causing you some issues, but ? never tried this one...

Justin

[Zeteg]

Thanks, it was the semicolen. Silly mistakes... thank you so much for pointing it out. I probably never would've found it =\

[mcibor]

BTW Welcome to WebmasterWorld!

And use the "enter" key more... :) It will save lot of fuss with errors, and the code will be pleasanter to read.

Try sth like this:

<?php
$user = "weeee";
$password = "rraaawwwrrr";
$database = "eeeeeep";

mysql_connect ("localhost", $user, $password);
@mysql_select_db ($database) or die ("Unable to select database");

$query="CREATE TABLE survey (
id int(6) NOT NULL auto_increment,
age1 varchar(1) NOT NULL,
age2 varchar(1) NOT NULL,
gender1 varchar(1) NOT NULL,
gender2 varchar(1) NOT NULL,
cell1 varchar(1) NOT NULL,
cell2 varchar(1) NOT NULL,
...
PRIMARY KEY (id),
UNIQUE id (id),
KEY id_2 (id)
)";

mysql_query($query);
mysql_close();
?>

Much better, isn't it?

Best regards
Michal Cibor

PS. Here you can't see the spaces on new lines, but there should be some as well in your final code