删除在while循环中无法正常工作

Question

here i am trying to delete from detail table here is one problem with my code if detail table have three records than only delete one record from detail table.and also it does not effect other two records in stock table.. Only one first record this code work properly after that it does not work in for delete query from detail table and not effected in stock table...

<?php
include("include/config.inc.php");


$purchaseMasterId = isset($_REQUEST['purchaseMasterId']) ? $_REQUEST['purchaseMasterId'] : 0;

if($purchaseMasterId > 0) {
    $k = 0;
    $selectMaster = "SELECT purchasedetail.purchaseMasterId, colorId, 
                            totalkg, purchaseDetailId, partyId
                    FROM purchasedetail  
                        JOIN purchasemaster ON 
                            purchaseMaster.purchaseMasterId = purchasedetail.purchaseMasterId
                    WHERE purchasedetail.purchaseMasterId  = ".$_REQUEST['purchaseMasterId'];

    $selectMasterRes = mysql_query($selectMaster);
    while($purRow = mysql_fetch_array($selectMasterRes)) {
        $purchaseDetailId   = $purRow['purchaseDetailId'];
        $purchaseMasterId   = $purRow['purchaseMasterId'];
        $colorId            = $purRow['colorId'];
        $totalkg            = $purRow['totalkg'];
        $partyId            = $purRow['partyId'];

        $select = "SELECT qty
                    FROM stock
                    WHERE partyId = ".$partyId."
                    AND colorId = ".$colorId;

        $selectRes = mysql_query($select);
        if($stockRow = mysql_fetch_array($selectRes)) {
            $current = $stockRow['qty'];
        }

        $updateStock = "UPDATE stock
                        SET qty = ".$current." - ".$totalkg."
                    WHERE partyId = ".$partyId."
                      AND colorId = ".$colorId;

        $updateStockRes = mysql_query($updateStock) or die(mysql_error());
        if($updateStockRes) {
            $deleteDt = "DELETE FROM purchasedetail 
                        WHERE purchaseDetailId  = ".$purchaseDetailId;

            $deleteRes = mysql_query($deleteDt);
            if($deleteRes){
                $deleteMst = "DELETE FROM purchasemaster 
                             WHERE purchaseMasterId  = ".$_REQUEST['purchaseMasterId'];

                $deleteMstRes = mysql_query($deleteMst) or die(mysql_error());
                if(!$deleteMstRes) {
                    echo "Purchase Master Delete Fail";
                } else {
                    header("Location:purdetail.php");
                    exit();
                }
            }
        }
    }
} 
?>

Answer 1

Here is my updated code with perfect code working

   <?php
    include("include/config.inc.php");

    $purchaseMasterId = isset($_REQUEST['purchaseMasterId']) ? $_REQUEST['purchaseMasterId'] : 0;

    if($purchaseMasterId > 0)
    {
        $k = 0;
        $selectMaster = "SELECT purchasedetail.purchaseMasterId,colorId,totalkg,purchaseDetailId,partyId
                            FROM purchasedetail  
                        JOIN purchasemaster ON purchasemaster.purchaseMasterId = purchasedetail.purchaseMasterId
                             WHERE purchasedetail.purchaseMasterId  = ".$_REQUEST['purchaseMasterId'];
        $selectMasterRes = mysql_query($selectMaster) or die(mysql_error());
        while($purRow = mysql_fetch_array($selectMasterRes))
        {
          $purchaseDetailId   = $purRow['purchaseDetailId'];
          $purchaseMasterId   = $purRow['purchaseMasterId'];
          $colorId            = $purRow['colorId'];
          $totalkg            = $purRow['totalkg'];
          $partyId            = $purRow['partyId'];



            $select = "SELECT qty
                         FROM stock
                       WHERE partyId = ".$partyId."
                       AND colorId = ".$colorId;
            $selectRes = mysql_query($select);
            if($stockRow = mysql_fetch_array($selectRes))
            {
              $current = $stockRow['qty'];
            }

            $updateStock = "UPDATE stock
                              SET qty = ".$current." - ".$totalkg."
                              WHERE partyId = ".$partyId."
                            AND colorId = ".$colorId;
            $updateStockRes = mysql_query($updateStock) or die(mysql_error());
            if($updateStockRes)
            {
              $deleteDt = "DELETE FROM purchasedetail 
                             WHERE purchaseDetailId  = ".$purchaseDetailId;
              $deleteRes = mysql_query($deleteDt);
              if($deleteRes)
              {
                $selectid = "SELECT purchaseDetailId
                                FROM purchasedetail
                             WHERE purchaseMasterId  = ".$purchaseMasterId;
                $selectidRes = mysql_query($selectid);
                if(mysql_affected_rows() == 0)
                {
                  $mst = "DELETE FROM purchasemaster
                             WHERE purchaseMasterId  = ".$purchaseMasterId;
                  $mstRes = mysql_query($mst) or die(mysql_error());;   
                  if($mstRes)
                  {
                    header("Location:purdetail.php");
                    exit();
                  }
                  else
                  {

                  }
                }
              }
            }
        }
    } 
    ?>