Hey, can anyone enlighten me why I have 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 'condition='Poor', account_number='N/A1',

 

It only seems to happen when i add the condition column into the query. This is the only problem, when I remove it the update query works fine without any errors.

 

Any chance someone knows were I'm going wrong?

 

Thanks, Adam

http://dev.mysql.com/doc/refman/5.5/en/reserved-words.html

CONDITION is a reserved keyword

you could still use it by escaping the name using backticks, so

`condition` would work fine