query("quotes", "UPDATE quotes SET `client_id` = '{$_POST['client_id']}', `order_type` = '{$_POST['order_type']}', `user_id` = '{$_SESSION['user_id']}', `status` = 'OPENED', `subject` = '$subject', `notes` = '$note', `terms` = '$terms',`area`='$area',`additional_delivery_details`='$additional_delivery_details' WHERE record_id = '{$_POST['record_id']}'"); $db->query("quote_list", "DELETE FROM quote_list WHERE `quote_id` = '$quote_id'"); $stokc_items_arr = $_POST['stock_id']; $index = 0; foreach ($stokc_items_arr as $item_name) { if (empty($item_name)) continue; // echo $item_name . "
"; $stock_res = $db->query("stock", "SELECT * FROM stock WHERE `code` = '$item_name'"); $stock = $stock_res->fetch_assoc(); $item_id = $stock['record_id']; // echo $function->number_to_save($_POST['price'][$index]); $db->query("quote_list", "INSERT INTO quote_list (`quote_id`,`stock_id`,`qty`,`price`,`size_m`,`pannels`) VALUES ('$quote_id', '$item_id','{$_POST['qty'][$index]}','" . $function->number_to_save($_POST['price'][$index]) . "','{$_POST['size_m'][$index]}','{$_POST['pannels'][$index]}')"); $index++; } header("location:home.php");