query("leads", "UPDATE `leads` SET `jc_no`='$jc_no',`contact_number`='$contact_number',`other_number`='$other_number',`alternate_number`='$alternate_number',`area`='$area',`type`='$type',`user_created_id`='$user_created_id',`payment_made`='$payment_made',`payment_type`='$payment_type',`slip_image`='$slip_path',`amount`=$amount,`team_assigned_id`='$team_assigned_id',`additional_notes`='$additional_notes',`status`='$status' WHERE `record_id` = '{$_POST['record_id']}'"); $update_jobcards = $db->query("jobcards", "UPDATE `jobcards` SET `team_assigned_id`='$team_assigned_id' WHERE `jc_no` = '$jc_no'"); } else { $update_leads = $db->query("leads", "UPDATE `leads` SET `jc_no`='$jc_no',`contact_number`='$contact_number',`other_number`='$other_number',`alternate_number`='$alternate_number',`area`='$area',`type`='$type',`user_created_id`='$user_created_id',`payment_made`='$payment_made',`payment_type`='$payment_type',`slip_image`='$slip_path',`amount`='$amount',`team_assigned_id`='$team_assigned_id',`additional_notes`='$additional_notes',`status`='$status' WHERE `record_id` = '{$_POST['record_id']}'"); } echo "";