query("work_orders", "UPDATE `work_orders` SET `project_id` = '{$_POST['project_id']}', `date_time_created` = '{$_POST['date_time_created']}', `description` = '', `work_order_type_id` = '{$_POST['work_order_type_id']}', `deadline_date_time` = '{$_POST['deadline_date_time']}', `user_id` = '{$_SESSION['user_id']}', `user_id_assigned` = '{$_POST['user_id_assigned']}', `name` = '{$_POST['name']}', `notes` = '{$_POST['notes']}', `completed` = $completed, `inprogress` = $inprogress, `in_review` = $in_review, `sent_for_review` = $sent_for_review, `user_id_review` = '{$_POST['user_id_review']}', `singed_off` = 0, `pictures` = '', `action_date_time` = '{$_POST['action_date_time']}', `public_holiday` = 0 WHERE `record_id` = '{$_POST['record_id']}'"); $index = 1; while ($index < count($_POST)) { if ($_POST['instruction_' . $index] != '') { $db->query("work_orders_instructions", "INSERT INTO `work_orders_instructions`(`work_order_id`, `instruction`, `user_id`, `marked`, `file_name`,`date_time_created`) VALUES ({$_POST['record_id']},'{$_POST['instruction_' . $index . '']}',{$_SESSION['user_id']},0,'','$date')"); } $index++; } $index = 1; while ($index <= count($_POST) + 2) { if ($_POST['resource_' . $index] != '') { echo $_POST['resource_' . $index]; $db->query("work_order_resources", "INSERT INTO `work_order_resources`(`type`, `link`, `user_id`, `date_time`, `work_order_id`, `name`) VALUES ('FILE','{$_POST['file_' . $index]}',{$_SESSION['user_id']},'$date',{$_POST['work_order_id']},'{$_POST['resource_' . $index]}')"); } $index++; } $index = 1; var_dump($_POST); while ($index <= count($_POST) + 2) { if ($_POST['log_' . $index] != '') { echo $_POST['log_' . $index]; $db->query("work_order_logs", "INSERT INTO `work_order_logs`(`work_order_id`, `log`, `user_id`,`date_time`) VALUES ({$_POST['work_order_id']},'{$_POST['log_' . $index . '']}',{$_SESSION['user_id']},'$date')"); } $index++; } echo "";