Question

php页面 sql修改语句怎么写?

$id = $_POST['id'];
$ming = $_POST['ming'];
$mima = md5_pwd($_POST['mima']);
$dizi = $_POST['dizi'];
$cid = $_POST['cid'];
$sql = "UPDATE `JPNG` SET `ZH_name`=`$ming`,`ZH_mima`=`$mima`,`ZH_cid`=`$cid` WHERE `ZH_id`=$id";
$coco = mysql_query($sql);
if ($coco) {
go("修改成功","./YHxx.php");
} else {
back("修改失败");
}

Answer 1

你的这一句有错误

$sql        = "UPDATE  `JPNG` SET `ZH_name`='$ming',`ZH_mima`='$mima',`ZH_cid`='$cid' WHERE `ZH_id`= $id";

在Mysql里，字段名为 ` 符号，内容为 '或者"