$sqlstr = "update chuku set out_list='".$_POST[out_list]."',order_number='".$_POST[order_number]."',out_data='".$_POST[out_data]."',product=$product,product1 = $product1,product2 = $product2,product3 = $product3',user_name = '".$_POST[user_name]."',custos = '".$_POST[custos]."',deal_name = '".$_POST[deal_name]."' where id = ".$_POST[id] or die(mysql_error());错误提示:
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 '@20100112@1人份/袋@200@1@2,product1 = 手机@2010082' at line 1
想问下,在更新语句中,想product=$product这种写法正确吗,如果不正确的话,正确的写法该怎么写啊,加双引号和单引号都不行啊!
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 '@20100112@1人份/袋@200@1@2,product1 = 手机@2010082' at line 1
想问下,在更新语句中,想product=$product这种写法正确吗,如果不正确的话,正确的写法该怎么写啊,加双引号和单引号都不行啊!
解决方案 »
- 向postgersql中存图片
- 表联接
- 如何将c#的image存储为postgreSQL的bit类型
- mysql一个很让人不解的问题(关于编码)
- 为什么只查出来一条记录?
- 在lunux环境下怎么找到PHP跟MYSQL连接的语句?
- 谁会用MySQL-Front,高手过来看看啊,崩溃啦!!!
- 为什么没有mysql.server呢?
- mysql中...怎样给一张表设置"主"键字段......
- 5.5.16版,Assertion failure in thread *** in file rem0rec.c line 561
- 求助。mysql插入字段错误
- !(新手请教)mysql如何把本地表导入到服务器的mysql中
update chuku set out_list='11111',order_number='',out_data='2011-01-12',product=手机@20100112@1人份/袋@200@1@2,product1 = 电脑@20100829@1人份/袋@200@1@2,product2 = 手机@20110104@1人份/袋@400@1@2,product3 = @@@@@',user_name = 'aaaaaa',custos = '刘XX',deal_name = '于XX' where id = 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 '@20100112@1人份/袋@200@1@2,product1 = 电脑@2010082' at line 1
试试