[請益] foreach中使用mysqli_multi_query發生錯誤
我是PHP新手想問各位大大一個問題..
我想要在刪除一筆會員資料的同時更改respondent table的userid
$_GET['chose']是表單裡面有核選的會員id
foreach($_GET['chose'] as $uid)
{
$sql2="delete from member where userid='$uid' limit 1;";
$sql2.="update respondent set userid=0 where userid='$uid';";
$query2=mysqli_multi_query($nfdb, $sql2) or die(mysqli_error($nfdb));
}
選取單筆會員資料時可以正常執行
當我選取複數的會員資料時出現以下錯誤訊息
Commands out of sync; you can't run this command now
感謝benck的回應
修改過後已經可以執行了
修改成以下
$sql2="";
foreach($_GET['chose'] as $uid)
{
$sql2.="delete from member where userid='$uid' limit 1;";
$sql2.="update respondent set userid=0 where userid='$uid';";
}
$query2=mysqli_multi_query($nfdb, $sql2) or die(mysqli_error($nfdb));
不過小弟愚鈍還是不懂為什麼$query2這行放到foreach末行就又出現錯誤訊息了
請問有人可以解釋清楚一點嗎..@@
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 220.136.216.64
※ 編輯: wickyshiang 來自: 220.136.216.64 (11/09 18:33)
→
11/09 20:02, , 1F
11/09 20:02, 1F
※ 編輯: wickyshiang 來自: 220.136.216.64 (11/09 20:51)
→
11/10 00:02, , 2F
11/10 00:02, 2F
推
11/10 00:03, , 3F
11/10 00:03, 3F
→
11/10 06:50, , 4F
11/10 06:50, 4F
→
11/10 06:55, , 5F
11/10 06:55, 5F
→
11/10 10:49, , 6F
11/10 10:49, 6F
→
11/10 10:50, , 7F
11/10 10:50, 7F
→
11/10 17:50, , 8F
11/10 17:50, 8F