Forum Moderators: coopster

Message Too Old, No Replies

Syntax Error Creating Table

Someone see something I don't?

         

capulet_x

9:54 pm on Apr 14, 2007 (gmt 0)

10+ Year Member



mysql_query("CREATE TABLE chat(
id int(11) NOT NULL auto_increment,
login VARCHAR(20) NOT NULL default '',
message VARCHAR(255) NOT NULL default '', <---this is line 6
itstime VARCHAR(10) NOT NULL default '',
PRIMARY KEY (`id`)") or die(mysql_error());
echo "Table Created!";

I get this error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 6

capulet_x

11:15 pm on Apr 14, 2007 (gmt 0)

10+ Year Member



Never mind. I got it sorted.

mysql_query("CREATE TABLE chat(
id INT(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY(id),
login VARCHAR(20) NOT NULL DEFAULT '',
message VARCHAR(255) NOT NULL DEFAULT '',
itstime VARCHAR(10) NOT NULL DEFAULT '')")
or die(mysql_error());