problem with update query

brad-taylor1978

Hey guys,
im having a problem with an update query and wonder if you could help point out the problem. Here is my query and the or die statement im getting.

UPDATE message_center SET read = 'y' WHERE msg_id = '3'

problem is: 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 'read = 'y' WHERE msg_id = '3'' at line 1

Any thoughts?
Thanks

Dlex

are you trying to update through a form or something here.

Lars_Berg

read is a reserved word in SQL. Use another column name.

brad-taylor1978

of course it is... I knew it was something dumb.

Thanks Lars.

bradgrafelman

Lars Berg wrote:
Use another column name.

Or simply surround the column name in backticks:

UPDATE `message_center` SET `read` = 'y' WHERE `msg_id` = 3

Also, if msg_id is a numerical column, you shouldn't use quotes around the (numerical) value.

Either way, don't forget to mark this thread resolved.