SQL update problem

[JJBlaha]

if($read == '0') {
$sql2 = "UPDATE privatemessages SET read = '1' WHERE id='$id'";
$result2 = @mysql_query($sql2,$connection);
if($result2) {
echo "great success!";
} else {
echo "you fail!";
}
}

outputs you fail!

i know the id whatever is there, and i know the read is set to 0 there so why doesnt the script work?

[SharkBait]

Change it to read:
[code]
<?php

$result2 = mysql_query($sql2, $connection) or die("MySQL Error: <br />{$sql2}<br /> ". mysql_error());

?>
[/code]

the die() section will stop the rest of the script and the mysql_error() will output what is wrong if its a MySQL issue.

[JJBlaha]

MySQL Error:
UPDATE privatemessages SET read = '1' WHERE id='7'
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 id='7'' at line 1

is what i get.

[trq]

I assume $read is NOT a string.

[code=php:0]
if($read == 0) {
[/code]

[SharkBait]

read is a function of MySQL

Enclose read with backticks (next to the 1 key)

[code]
<?php
UPDATE privatemessages set `read` = '1' WHERE id = '{$id}'
?>
[/code]

[JJBlaha]

Thanks that worked beautifully :) If i had chosen something other than read such as r121 i would not have had to do that?

[trq]

[quote]If i had chosen something other than read such as r121 i would not have had to do that?[/quote]

yeah... didn't even pick up on that. read is a reserved word in MySql.