php – MYSQL语法错误1064

发布时间：2020-12-13 21:35:56 所属栏目：PHP教程来源：网络整理

导读：我只是想弄清楚为什么从这个查询得到错误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_nam

我只是想弄清楚为什么从这个查询得到错误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”附近使用正确的语法

任何帮助

解决方法

删除逗号之前,应该是

$query = "UPDATE IT_manufacturer SET manufacturer_name = '{$manufacturer_name}',manufacturer_display_name = '{$manufacturer_display_name}' 
                 WHERE manufacturer_id = {$manufacturer_id} ";

逗号只分隔设置的不同变量,而不是从哪里设置.

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!