exec_query('inspections', ['*'], '', '', '', '', $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_record_id']}"); $asset_info = $asset_info_res->fetch_assoc(); $user_info_res = $db->exec_query('users', ['*'], '', '', '', '', "record_id = {$job_card['user_id']}"); $user_info_created = $user_info_res->fetch_assoc(); $inspection_res = $db->exec_query('pre_inspection_content', ['*'], '', '', '', '', "record_id = {$job_card['inpection_id']}"); $inspection = $inspection_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'], $inspection['name'], $job_card['questions'], $job_card['answers'], $asset_info['fleet_no'], $asset_info['description'], $user_info_created['username'], $job_card['date_time'], $job_card['notes'], $farm['farm_name'], $job_card['question_notes']]; } $date = date("Y_m_d"); $fp = fopen("../temp/" . $date . "_inspections_report.csv", 'w'); foreach ($list as $fields) { fputcsv($fp, $fields); } fclose($fp); echo ""; // echo ""; // unlink("../temp/".$date."_report.csv");