Syntax Error

[EchoFool]

I have a syntax error but not sure how to correct it.

 

The idea is to change all rows with an id equal to or "less than" the value but i get this:

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 '=<'220'' at line 1

 

This is what i put:

 

$Change = mysql_query("UPDATE messages SET Staff='0' WHERE Staff='{$_SESSION['Current_User']}' AND Sender='$ID' AND MessageID=<'{$row['MessageID']}'")
Or die(mysql_error());

[schilly]

Try

$Change = mysql_query("UPDATE messages SET Staff='0' WHERE Staff='$_SESSION['Current_User']' AND Sender='$ID' AND MessageID='$row['MessageID']'")
Or die(mysql_error());

 

If you haven't done any variable validation you may get errors as well.

[trq]

$Change = mysql_query("UPDATE messages SET Staff='0' WHERE Staff = '{$_SESSION['Current_User']}' AND Sender = '$ID' AND MessageID <= '{$row['MessageID']}'")
Or die(mysql_error());

[EchoFool]

$Change = mysql_query("UPDATE messages SET Staff='0' WHERE Staff = '{$_SESSION['Current_User']}' AND Sender = '$ID' AND MessageID <= '{$row['MessageID']}'")
Or die(mysql_error());

Argh thank you ! Had the <= the wrong way round!

[EchoFool]

Where is the topic solved button gone?