关于PHP语言中SQL语法的问题

来源：百度知道 编辑：UC知道 时间：2024/05/21 07:20:36
$sqlzz = 'INSERT INTO ' .$GLOBALS['ecs']->table('user_address').
' (user_id, tel, mobile, address, consignee, zipcode) '.
"VALUES ('$newid', '$tel', '$mobile', '$address', '$consignee', '$zipcode')";

楼主的sql没有问题 规范一点的话 顶多在表名,字段名上加`
例如:
$sqlzz = 'INSERT INTO `' .$GLOBALS['ecs']->table('user_address').
'` (`user_id`, `tel`, `mobile`, `address`, `consignee`, `zipcode`) '.
"VALUES ('$newid', '$tel', '$mobile', '$address', '$consignee', '$zipcode')";

错误的信息应该贴出来

楼上的写的不规范!
$sqlzz="insert into ".$GLOBALS['ecs']->table('user_address')." values
('".$newid."', '".$tel."', '".$mobile."', '".$address."', '".$consignee."', '".$zipcode."')";

$sqlzz = 'INSERT INTO ' .$GLOBALS['ecs']->table('user_address').
' (user_id, tel, mobile, address, consignee, zipcode) '.
"VALUES ($newid, $tel, $mobile, $address, $consignee, $zipcode)";

这样试下