"; // echo "
jc no: " . $_POST['jc_no']; // echo "
status: " . $_POST['status']; // echo "
team assigned id: " . $_POST['team_assigned_id']; // echo "
additional notes: " . $_POST['additional_notes']; // echo "

"; // echo "UPDATE `leads` SET `STATUS` = '{$_POST['status']}', `additional_notes` = '{$_POST['additional_notes']}', `team_assigned_id` = '{$_POST['team_assigned_id']}' WHERE `jc_no` = '{$_POST['jc_no']}'"; $lead_done = $db->query("leads", "UPDATE `leads` SET `STATUS` = '{$_POST['status']}', `additional_notes` = '{$_POST['additional_notes']}', `team_assigned_id` = '{$_POST['team_assigned_id']}' WHERE `jc_no` = '$_POST[jc_no]'"); $jobcard_id = $db->query("jobcards", "INSERT INTO `jobcards`(`jc_no`,`date_created`,`user_id`, `team_assigned_id`) VALUES('{$_POST['jc_no']}','{$date}','{$_SESSION['user_id']}','{$_POST['team_assigned_id']}')"); // echo "

"; // echo "
INSERT INTO `jobcards`(`jc_no`,`date_created`,`user_id`, `team_assigned_id`) VALUES('{$_POST['jc_no']}','{$date}','{$_SESSION['user_id']}','{$_POST['team_assigned_id']}')"; // echo "

"; // echo "
contact number: " . $_POST['contact_number']; // echo "
other number: " . $_POST['other_number']; // echo "
alternate number: " . $_POST['alternate_number']; // echo "
address: " . $_POST['address']; // echo "
slip: " . $_POST['slip']; // echo "
record_id: " . $jobcard_id; // echo "

"; // echo "
UPDATE `jobcards` SET `contact_number` = '{$_POST['contact_number']}', `other_number` = '{$_POST['other_number']}', `alternate_number` = '{$_POST['other_number']}', `address` = '{$_POST['address']}', `slip` = '{$_POST['slip']}' WHERE `jc_no` = '{$_POST['jc_no']}'"; $update_jobcard = $db->query("jobcards", "UPDATE `jobcards` SET `contact_number` = '{$_POST['contact_number']}', `other_number` = '{$_POST['other_number']}', `alternate_number` = '{$_POST['other_number']}', `address` = '{$_POST['address']}', `slip` = '{$_POST['slip']}' WHERE `jc_no` = '{$_POST['jc_no']}'"); } else { // echo "
UPDATE `leads` SET `STATUS` = '$_POST[status]', `additional_notes` = '$_POST[additional_notes]' WHERE `jc_no` = '$_POST[jc_no]'"; $lead_updated = $db->query("leads", "UPDATE `leads` SET `STATUS` = '$_POST[status]', `additional_notes` = '$_POST[additional_notes]' WHERE `jc_no` = '$_POST[jc_no]'"); } echo "";