mysql语法错误1064_php – MYSQL语法错误1064

我只是想弄清楚为什么从这个查询得到错误1064

//prep the data for database use

$manufacturer_id = $_GET['id'];

$manufacturer_display_name = mysql_prep($_POST['manufacturer_display_name']);

$manufacturer_name = mysql_prep($_POST['manufacturer_name']);

$query = "UPDATE IT_manufacturer SET

manufacturer_name = '{$manufacturer_name}',

manufacturer_display_name = '{$manufacturer_display_name}',

WHERE manufacturer_id = {$manufacturer_id}

";

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

confirm_query ($result);

如果我回显变量$manufacturer_name,$manufacturer_display_name,$manufacturer_id它们都有值但是我收到此错误

无法执行查询您的SQL语法中有错误;检查与您的MySQL服务器版本对应的手册,以便在第4行错误编号1064的“WHERE manufacturer_id = 1”附近使用正确的语法

任何帮助