exec_query('job_cards', ['*'], '', '', '', '', $where_data, 'ORDER BY record_id DESC'); while($job_card = $jobcards_res->fetch_assoc()){ $asset_info_res = $db->exec_query('assets', ['*'], '', '', '', '', "record_id = {$job_card['asset_id']}"); $asset_info = $asset_info_res->fetch_assoc(); $user_info_res = $db->exec_query('users', ['*'], '', '', '', '', "record_id = {$job_card['user']}"); $user_info_created = $user_info_res->fetch_assoc(); $user_info_res = $db->exec_query('users', ['*'], '', '', '', '', "record_id = {$job_card['user_id_opened']}"); $user_info_opened = $user_info_res->fetch_assoc(); $user_info_res = $db->exec_query('users', ['*'], '', '', '', '', "record_id = {$job_card['user_id_closed']}"); $user_info_closed = $user_info_res->fetch_assoc(); $farm_id_res = $db->exec_query('farms',['*'],'','','','',"record_id = {$job_card['farm_id']}"); $farm = $farm_id_res->fetch_assoc(); $list[] = [$job_card['record_id'],$job_card['job_card_status'],$asset_info['description'],$asset_info['fleet_no'],$job_card['parts'],$job_card['notes'],$user_info_created['username'],$job_card['date_time_created'],$job_card['date_time_opened'],$job_card['date_time_closed'],$job_card['job_card_type'],$job_card['odo'],$job_card['warning_questions'],$user_info_opened['username'],$user_info_closed['username'],$farm['farm_name']]; } $date = date("Y_m_d"); $fp = fopen("../temp/".$date."_job_cards_report.csv", 'w'); foreach ($list as $fields) { fputcsv($fp, $fields); } fclose($fp); echo ""; // echo ""; // unlink("../temp/".$date."_report.csv");