SQL Syntax Error?

[rapmonkey]

I get this error:

Gravity Board X experienced an error while trying to create the IMs table: You have an error in your SQL syntax near 'from TINYINT, to TINYINT, imid INT AUTO_INCREMENT, PRIMARY KEY(imid))' at line 1

While running this line of code:

mysql_query("CREATE TABLE " . $prefix . "ims (imbody TEXT, imsubject TINYTEXT, imdate DATETIME, reply TINYTEXT, replytime DATETIME, from TINYINT, to TINYINT, imid INT AUTO_INCREMENT, PRIMARY KEY(imid))") OR DIE ("Gravity Board X experienced an error while trying to create the IMs table: " . mysql_error());

Does anyone know what is wrong? 🙁

I'll appreciate any help. 🙂

[Lars_Berg]

from and to are reserved words and should not be used as column names.

[orangehairedboy]

Not to say that they can't be used as column names...you can avoid this problem by enclosing the colum names in back ticks (next to the 1):

select from from mytable where select=123;

That's just an example of how you can use anything as a column name...but you still shouldn't...it's bad practice 🙂