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