num_rows > 0) { while ($pump_jobcards = $pump_jobcards_res->fetch_assoc()) { if ($pump_jobcards['client_type'] == "NEW") { $contact_number = $pump_jobcards['contact_number'] ?? ''; $address = $pump_jobcards['address'] ?? ''; // echo $contact_number; // echo $address; } else { $existing_pump_res = $db->query("pump_installation", "SELECT * FROM pump_installation WHERE record_id = '{$pump_jobcards['installation_id']}'"); // echo "SELECT * FROM pump_installation WHERE record_id = '{$pump_jobcards['installation_id']}'"; $existing_pump = $existing_pump_res->fetch_assoc(); $contact_number = $existing_pump['contact_number'] ?? ''; $address = $existing_pump['area'] ?? ''; } ?> No Active Jobcards"; } ?>