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:
and here is my error message:
$result = mySQLQuery("UPDATE mail SET read = 1 WHERE mail_id = $mailid AND client_id = 0");
Am I overlooking something very simple here? All column names, table names and variable names are correct.
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