update query problem

[o~~Goatee~~o]

Hi there

I seem to be having an issue which really shouldn't be an issue but I'm obviously missing something..... I want to update 1 value in my MySQL db through a PHP script. I'm passing my query to a function that I use for all my queries but it doesn't work. Here is the php:

$result = mySQLQuery("UPDATE mail SET read = 1 WHERE mail_id = $mailid AND client_id = 0");

and here is my error message:

Query problem ! MySQL says: You have an error in your SQL syntax near 'read = 1 WHERE mail_id = 12 AND client_id = 0' at line 1 and the query is UPDATE mail SET read = 1 WHERE mail_id = 12 AND client_id = 0

Am I overlooking something very simple here? All column names, table names and variable names are correct.

Many thanks

[r937]

READ is a reserved word, so you have to put it in backticks

[o~~Goatee~~o]

lol, d'oh. I thought I was going mad for a second. Thanks for pointing that out