exec_query('assets', ['*'], '', '', '', '', $where_data, 'ORDER BY record_id DESC'); while ($job_card = $jobcards_res->fetch_assoc()) { $farm_id_res = $db->exec_query('farms', ['*'], '', '', '', '', "record_id = {$job_card['farm_id']}"); $farm = $farm_id_res->fetch_assoc(); $asset_group = $db->exec_query('asset_types',['*'],'','','','',"record_id = {$job_card['asset_type_id']}"); $asset_type = $asset_group->fetch_assoc(); $list[] = [$job_card["record_id"],$asset_type["asset_type_name"],$job_card["asset_id"],$job_card["fleet_no"],$job_card["status"],$farm["farm_name"],$job_card["qr_code"],$job_card["license_exp_date"],$job_card["description"],$job_card["vin"],$job_card["fuel_size"]]; } $date = date("Y_m_d"); $fp = fopen("../temp/" . $date . "_assets_list.csv", 'w'); foreach ($list as $fields) { fputcsv($fp, $fields); } fclose($fp); echo ""; // echo ""; // unlink("../temp/".$date."_report.csv");