Problem with the word ADD
Posted: Mon Nov 30, 2009 7:38 am
I am having trouble creating a table with the name 'ADD' as a user submits this word in a php form. Any other user entry into the form works fine in creating a table.
Here is the error line "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 'add (Name VARCHAR(30), Day INT(3), Month VARCHAR(15), Year INT(5), Shift VARCHAR' at line 1"
Why only this error with the word 'ADD'
Help Please!
Here is the error line "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 'add (Name VARCHAR(30), Day INT(3), Month VARCHAR(15), Year INT(5), Shift VARCHAR' at line 1"
Why only this error with the word 'ADD'
Help Please!