PHP: Update database table

I'm trying to get this to update the messages table in my database, and set the message_read cell to 1.

But I can't get it to work. It always says 0 where it supposed to change to 1.

I'm pretty sure the variables are right.

$q = "UPDATE messages SET message_read='1' WHERE id='$messageid' AND to开发者_开发技巧_user='$usermsg'";
mysql_query($q);

I do not get any errors either.

"usermsg" = the session username

"messageid" = the id of the message

---

Try this:

$q = "UPDATE messages SET message_read='1' WHERE id=".mysql_real_escape_string($messageid)." AND to_user='".mysql_real_escape_string($usermsg)."';";

$result = mysql_query($q);

if(!$result)
{ 
    die( mysql_error() ); 
}
else
{
    echo 'Number of affected rows:'.mysql_affected_rows();
}

If there was something wrong with your query you will be able to see the error printed on screen. And if not you can see how many rows were affected by the query.

I've also added some SQL injection projection just in case.

---

I think this is the correct syntax:

$q = "UPDATE messages SET message_read = 1 WHERE id = ".$messageid." AND to_user='".$usermsg."'";

Don't use quotes when the field type is INT.