Frustrated MySQL User

OK... I've been constructing a PM system for a site I work with and have run into a really studpid syntax problem.

View of MySQL table structure

OK.. So here's the problem....

The query
-- UPDATE message SET date=1 WHERE ID=1
functions perfectly and will execute w/out error

But, the query
-- UPDATE message SET read=1 WHERE ID=1
gets the error
=== You have an error in your SQL syntax near 'read=1 WHERE ID=1' at line 1


Any clues on the correct syntax for that statement?

 

 

 

 

Top