What's Wrong?

[Pi_Mastuh]

I'm running this query:

$SQL = "UPDATE Mail SET read = '1' WHERE msgID = '$msgID'";
$result2 = mysql_query($SQL, $connection);

but nothing's happening. I try running the query on its own and substituing $msgID with an actualy number, but it says the query is wrong. Any ideas as to what's wrong?

[Psycho]

Try adding an error handler to see if anything useful is returned:

$result2 = mysql_query($SQL, $connection) or die ("The query:<br>".$sql."<br>Caused the following error:<br>".mysql_error());

[JasonLewis]

have you got a table called mail with the field called read. and the number that your using, is that already in the table. if you are trying to insert then maybe you want INSERT INTO Mail...

[TEENFRONT]

$result2 = mysql_query($SQL, $connection) or die ("The query:
".$SQL."
Caused the following error:
".mysql_error());

try that one instead - mjdamato had caps missing on the $SQL in the die() statement

[Pi_Mastuh]

I'm running a query that when you load the page it changes Read from 0 to 1 if it's 0. And I got the following error:

The query: UPDATE Mail SET read = '1' WHERE msgID = '1' Caused the following 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 'read = '1' WHERE msgID = '1'' at line 1

[TEENFRONT]

$SQL = "UPDATE `Mail` SET `read` = '1' WHERE `msgID` = '$msgID'";


try that for your $SQL

[Pi_Mastuh]

It works, thank you.

[TEENFRONT]

no problem.