join更新数据失败,请团队帮助我进行更新
$result = "UPDATE manager m INNER JOIN user u ON
m.manager_phone='$manager_phone', m.manager_fax='$manager_fax', m.manager_email='$manager_email', u.fullname='$fullname', u.address='$address',
u.occupation='$occupation' WHERE manager_id='$id'";
$stmt = $connpdo->prepare($result);
$stmt->execute();
if ($stmt)
{
echo "ok";
exit;
}
else
{
echo "fail";
exit;
}
发布于 2018-08-04 04:26:08
您的语句格式不正确,并且没有SET语句。这是你想要的吗?
$result = "UPDATE manager m
INNER JOIN user u ON m.manager_id = u.user_id
SET m.manager_phone='$manager_phone',
m.manager_fax='$manager_fax',
m.manager_email='$manager_email',
u.fullname='$fullname',
u.address='$address',
u.occupation='$occupation'
WHERE manager_id='$id'
";
https://stackoverflow.com/questions/51679489
复制相似问题