Correct syntax ?

[baffled_in_UK]

Have I got anything wrong with this bit of code 'cos it won't create the table.

$db = mysql_connect("localhost", "user", "password"); mysql_select_db("database",$db) or die ("could not create connect" );  

mysql_query("CREATE TABLE table1 (
	field1 mediumint(9) DEFAULT '0' NOT NULL,	
	field2 timestamp(14),
	field3 varchar(255) NOT NULL,
	KEY Id (field1)") or die ("could not create table: adclicks" ); 

Thanks

[hand]

Generally print out all possible error messages, like "MySQL-Error: 1064 -> You have an error in your SQL syntax near '' at line 5",
so it is quiet easy to find the error

... or print "&gt;&gt;&gt; MySQL-Error: ".mysql_errno()." -&gt; ".mysql_error()."<br>\n";

In your code you forgot a ")" after index definition (Field1))

$db = mysql_connect("localhost", "user", "password")
   or print "&gt;&gt;&gt; MySQL-Error: ".mysql_errno()." -&gt; ".mysql_error()."<br>\n";

mysql_select_db("database",$db)
   or print "could not create connect &gt;&gt;&gt; MySQL-Error: ".mysql_errno()." -&gt; ".mysql_error()."<br>\n";  

mysql_query("CREATE TABLE table1 (
                          field1 mediumint(9) DEFAULT '0' NOT NULL,    

                          field2 timestamp(14),
                          field3 varchar(255) NOT NULL,
                          KEY Id (field1))")
	or print "could not create table: adclicks &gt;&gt;&gt; MySQL-Error: ".mysql_errno()." -&gt; ".mysql_error()."<br>\n";

[baffled_in_UK]

Thanks, much appreciated.