PHP插数据问题

来源:百度知道 编辑:UC知道 时间:2024/06/25 20:02:41
$sql="update c_drugstore set dru_name = '$dru_name',dru_addr = '$dru_addr',dru_inte = '$dru_inte',dru_post = '$dru_post',dru_principal = '$dru_principal',dru_linkman = '$dru_linkman',dru_phone = '$dru_phone',dru_fax = '$dru_fax',dru_subjection = '$dru_subjection',dru_GSP = '$dru_GSP',dru_state = '$dru_state',dru_city = '$dru_city',dru_dealarea = '$dru_dealarea',dru_dealmostly = '$dru_dealmostly',dru_commend = '$dru_commend',Cl_commendcomp = '$Cl_commendcomp',Cl_mien = '$Cl_mien',Cl_miencomp = '$Cl_miencomp',Cl_statecomp = '$Cl_statecomp',Cl_citycomp = '$Cl_citycomp',Cl_comp = '$Cl_comp' where dru_id = $dru_id";
$de=$db->query($sql);

$sql = "update hy_member set user_name = '$user_name' where user_id = $user_id";
$db->query($sql);

if($de){
echo

可能是$dru_id为空,在ELSE里面写下面一句代码就可以准确的看到问题:
echo "执行:{$sql}<br>错误:".mysql_error();

可能里面有些字段的值为空嘛!