mysql - while 循环更新查询不起作用

Question

当我尝试更新记录时，我的更新查询是这样的，它仅更新第一条记录，之后它为我提供所有其他记录

#1062 - key “processBackupIndex”有重复条目“8-2015-05-16-13-2015-05-23-0.001-0.000-1-R-RI”

   for($k=0; $k<count($_REQUEST['designMasterId']); $k++)
    {
      $designMasterId    = isset($_REQUEST['designMasterId'][$k]) && $_REQUEST['designMasterId'][$k] != '' ? $_REQUEST['designMasterId'][$k] : 0;
      $reciveWet         = isset($_REQUEST['reciveWet'][$k]) && $_REQUEST['reciveWet'][$k] != '' ? $_REQUEST['reciveWet'][$k] : 0;
      $rejWet            = isset($_REQUEST['rejWet'][$k]) && $_REQUEST['rejWet'][$k] != '' ? $_REQUEST['rejWet'][$k] : 0;
      $desWet            = isset($_REQUEST['desWet'][$k]) && $_REQUEST['desWet'][$k] != '' ? $_REQUEST['desWet'][$k] : 0;

         $updateProBck = "UPDATE processbackup 
                        SET rDate           = '".$recDate."',
                            reciveWet       = '".$reciveWet."',
                            nextProcessId   = ".$nextProcessId.",
                            processMasterId = ".$processMasterId.",
                            rejWet          = ".$preRej."+".$rejWet.",
                            status = 'R',
                            nxtstatus = 'RI'
                        WHERE designMasterId = ".$designMasterId."
                               AND nextProcessId = ".$nextProcessId."
                               AND desWet = ".$desWet;
                  $updateProBckRes = mysql_query($updateProBck);
                  if(!$updateProBckRes)
                  {
                    echo "Recive Process Backup Insert Fail";
                  }
                  else
                  {
                    header("Location:processRecive.php");
                  }
}

Answer 1

你必须更换你的

header("Location:processRecive.php");

到文件末尾跳出循环。

因为现在如果第一次更新成功，您将取消执行并将用户重定向到其他页面。

您的代码可能是:

    if(!$updateProBckRes)
    {
        echo "($k) Recive Process Backup Insert Fail";
        exit;
    }

}
header("Location:processRecive.php");