SQL SYNTAX ERROR help

benicio

The subject update failed.
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 'WHERE id = 6' at line 5.

THis error always shows when a menu is being edited.

Expand|Select|Wrap|Line Numbers

 $query = "UPDATE subjects SET 

menu_name = '{$menu_name}', 

position = {$position}, 

visible = {$visible},

WHERE id = {$id}"; 

$result = mysql_query($query, $connection);