query("book_stock", "SELECT COUNT(*) as total FROM book_stock"); $row = $order_no_data->fetch_assoc(); $order_no = "SO_" . ($row['total'] + 1); /* Insert order header */ $db->query("book_stock", "INSERT INTO `book_stock`(`order_no`, `team_assigned_id`, `booking_date`) VALUES ('$order_no', '$team_assigned', '$clean_date')" ); /* Loop through each row */ $index = 1; while ($index <= $rows) { $stock_no = $_POST["stock_no_" . $index]; // now directly from select $type = $_POST["type_" . $index]; $quantity = $_POST["quantity_" . $index]; $registration_no = $_POST["registration_no_" . $index]; $open_balance = $_POST["open_balance_" . $index]; $close_balance = $_POST["close_balance_" . $index]; /* Skip empty rows */ if (empty($stock_no) || empty($quantity)) { $index++; continue; } /* Look up item_name from stock table using stock_no */ $stock_lookup = $db->query("stock", "SELECT * FROM stock WHERE stock_no = '$stock_no' LIMIT 1" ); if ($stock_lookup && $stock_lookup->num_rows > 0) { $stock_row = $stock_lookup->fetch_assoc(); $item_name = $stock_row['item_name']; /* Insert line item */ $db->query("book_stock_list", "INSERT INTO `book_stock_list` (`order_no`, `pump_code`, `registration_no`, `stock_type_id`, `stock_no`, `item_name`, `amount`, `open_balance`, `close_balance`) VALUES ('$order_no', '$pump_code', '$registration_no', '$type', '$stock_no', '$item_name', '$quantity', '$open_balance', '$close_balance')" ); /* Record stock movement */ $db->query("stock_trans", "INSERT INTO `stock_trans`(`stock_no`, `item_name`, `quantity`, `status`, `order_no`) VALUES ('$stock_no', '$item_name', '$quantity', 'BOOKED OUT', '$order_no')" ); } $index++; } echo "";