MySQL/PHP Error - Code is perfect

[spoonman]

I've been having this problem with a PHP script. I think it may have to do with a PHP or MySQL config file or version.

Here is the 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 'condition,description,location,date) VALUES ('3323','555','partsimg/','partsimg/' at line 1"

Now this is a typical error but the code is perfect. There is nothing wrong with it. I have tried rewriting the lines and triple-checked it. The page worked perfectly on an older Plesk server but once I moved it to the new server (8.1), it started giving me this error.

What could be the problem?

 

[sergius]

Please try to grave quote `condition`

 

[spoonman]

now 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 1"

Like I said, I know 100% that there is no error in my code. I may have to move it to an old plesk server that we have.

I am at a crossroads because now I spent money to upgrade to 8.1 but my PHP/MySQL scripts do not work correctly on it. I can not have faith in my new server if I don't get PHP/MySQL working.

 

[sergius]

Originally posted by spoonman
Like I said, I know 100% that there is no error in my code.

Sir, Plesk 8.1 for Windows ships MySQL 5.
MySQL 4 is shipped with old Plesks.
Seems you are using some names which are keywords in MySQL 5 but were not in MySQL 4.

 

[spoonman]

Thanks alot for the help!!!

I found on this page: http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html

..that Condition is a reserved word...thats why!