jobcard_no: " . $_POST['jobcard_no']; echo "
booking_date: " . $_POST['date_booked']; echo "
clean booking date: " . $clean_date = str_replace("T", " ", $_POST['date_booked']); echo "
no_rows: " . $_POST['no_rows'] . "
"; $index = 1; while ($index <= $_POST['no_rows']) { echo "
I: " . $index; echo "
stock_no: " . $_POST["stock_no_" . $index]; echo "
item_name: " . $_POST["item_name_" . $index]; echo "
description: " . $_POST["description_" . $index]; echo "
quantity: " . $_POST["quantity_" . $index]; $stock_res = $db->query("stock_control", "SELECT * FROM stock_control WHERE record_id = '{$_POST['item_name_' . $index]}'"); while ($stock = $stock_res->fetch_assoc()) { $item_name = $stock['item_name']; echo "
item_name: " . $item_name . "
"; echo "
INSERT INTO `stock_trans`(`jobcard_no`, `stock_no`, `item_name`, `description`, `date_booked`, `quantity`) VALUES ('{$_POST['jobcard_no']}', '{$_POST['stock_no_' . $index]}', '{$item_name}', '{$_POST['description_' . $index]}', '{$clean_date}', '{$_POST['quantity_' . $index]}')"; $stock_trans = $db->query("stock_trans", "INSERT INTO `stock_trans`(`jobcard_no`, `stock_no`, `item_name`, `description`, `date_booked`, `quantity`) VALUES ('{$_POST['jobcard_no']}', '{$_POST['stock_no_' . $index]}', '{$item_name}', '{$_POST['description_' . $index]}', '{$clean_date}', '{$_POST['quantity_' . $index]}')"); $new_quantity = $stock['quantity'] - $_POST['quantity_' . $index]; echo "
UPDATE `stock_control` SET `quantity` = '{$new_quantity}', `status` = '1' WHERE `record_id` = '{$stock['record_id']}'"; $update_stock = $db->query("stock_control", "UPDATE `stock_control` SET `quantity` = '{$new_quantity}', `status` = '1' WHERE `record_id` = '{$stock['record_id']}'"); } $index++; } echo "";