Sorry, no data available for export."; exit(); } // Set headers header("Content-type: application/vnd.ms-excel"); header("Content-Disposition: attachment; filename=DataExport_". date("mdy_Gis", $time) .".csv; size=$size_in_bytes"); header("Pragma: no-cache"); header("Expires: 0"); // Process rows $count = mysql_num_fields($export); for ($i = 0; $i < $fields; $i++) { $header .= mysql_field_name($export, $i) . "\t"; } if ($num_rows){ mysql_data_seek($export,0); } while($row = mysql_fetch_row($export)) { $line = ''; foreach($row as $value) { if ((!isset($value)) OR ($value == "")) { $value = "\t"; } else { $value = str_replace('"', '""', $value); $value = '"' . $value . '"' . "\t"; } $line .= $value; } $data .= trim($line)."\n"; } $data = str_replace("\r","",$data); echo $header."\n".$data; ?>