#1064-您的SQL语法出现错误；查看与MySQL服务器版本相对应的手册，了解附近要使用的正确语法 - #1064 - You have an error in your SQL syntax;heck the manual that corresponds to your MySQL server version for the right syntax to use near

#1064 - You have an error in your SQL syntax;heck the manual that corresponds to your MySQL server version for the right syntax to use near

下面是我的查询，当我在db中运行时，它显示错误，如#1064-您的SQL语法有错误；

  INSERT INTO`expense`(Request,Date,Employee,Load,Truck,Amount,Purpose,Mode,Remark) 
     VALUES ('$Request','$Date','$Employee','$Load','$Truck','$Amount','$Purpose','$Mode','$Remark')

可以帮忙吗！！

日期&Load是保留的关键字。使用反勾号-

INSERT INTO `expense` (`Request`,`Date`,`Employee`,`Load`,`Truck`,`Amount`,`Purpose`,`Mode`,`Remark`) 
 VALUES ('$Request','$Date','$Employee','$Load','$Truck','$Amount','$Purpose','$Mode','$Remark')

使用mysqli_real_escape_string可能会对包含字符串的变量产生问题

$Request = mysqli_real_escape_string($con, $Request);   
INSERT INTO `expense`(`Request`,`Date`,`Employee`,`Load`,`Truck`,`Amount`,`Purpose`,`Mode`,`Remark`) 
         VALUES ('".$Request."',............)