Create Table

[watagal]

Greetings,I have a PHP program creating 3 tables in mySQL (v5.0) - my syntax is:CREATE TABLE PageNavigator (id INT(10) NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), pid INT(10), title VARCHAR(64) NOT NULL, image VARCHAR(64), desc VARCHAR(128), link VARCHAR(128), inTest INT(1))CREATE TABLE PageCommand (id INT(10) NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), name VARCHAR(64) NOT NULL, link VARCHAR(128), desc VARCHAR(128), inTest INT(1))CREATE TABLE PageNavigator2PageCommand (idNav INT(10), idCmd INT(10), dspOrder INT(1))The first 2 do not get created, while the thied one does.on the first table, mysql_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 'desc VARCHAR(128), link VARCHAR(128), inTest INT(1))' at line 1"Can someone look at the syntax with a fresh set of eyes?TIA, Gal

[justsomeguy]

"desc" is a reserved word for use in ORDER BY, use a different name for your column.