add_styles_page(); // $html->check_user_type("ADMIN"); $db = new db_safeguard(); $leads_res = $db->query("work_requests", "SELECT * FROM work_requests WHERE type != 'JOBCARD' ORDER BY jc_no DESC"); if ($leads_res->num_rows > 0) { while ($leads = $leads_res->fetch_assoc()) { $user_res = $db->query("users", "SELECT * FROM users WHERE record_id = {$leads['user_id']}"); $user = $user_res->fetch_assoc(); $table_data = $table_data . " {$leads['jc_no']} {$leads['contact_number']} {$leads['address']} {$leads['type']} {$user['username']} {$leads['status']} "; } } else { $table_data = $table_data . " NO LEADS FOUND "; } ?>

UNASSIGNED LEADS

JOBCARD NO	CONTACT NUMBER	AREA	TYPE	CREATED BY	STATUS