$single_itemid = explode(",", $pitemids); $single_itemquantities = explode(",", $pitemremoveqty); foreach($single_itemid as $indx => $value) { $updateprodqty = mysqli_query($conn,"INSERT INTO itemqty(status, type, productid, storeid, admin, qty, time, date)VALUES('ACTIVE', 'Returned', '$single_itemid[$indx]', '$storeid', '$pcashier', '$single_itemquantities[$indx]', NOW(), NOW())")or die(mysqli_error($conn)); $updateqty = mysqli_query($conn,"UPDATE itembank SET qty=qty+$single_itemquantities[$indx], qtysold=qtysold-$single_itemquantities[$indx] WHERE productid='$single_itemid[$indx]' AND storeid='$storeid'") or die(mysqli_error($conn)); if($updateqty){ $qtyupdate .= ""; //insert into a future qtysale table if necessary } else{ $qtyupdate .= "Product I.D ".$single_itemid[$indx]." logged a quantity error
"; } } if($qtyupdate!=""){ echo $qtyupdate; } else{ echo "success"; }