// Export to CSV
IF($_GET['action'] == 'export') {
 
$rsSearchResults = mysql_query($sql, $db) or DIE(mysql_error());
 
$out = '';
 
$fields = mysql_list_fields('database','table',$db);
 
$columns = mysql_num_fields($fields);
 
 
// Put the name of all fields
 
FOR ($i = 0; $i < $columns; $i++) {
 
$l=mysql_field_name($fields, $i);
 
$out .= '"'.$l.'",';
 
}
 
$out .="\n";
 
 
// Add all values in the table
 
WHILE ($l = mysql_fetch_array($rsSearchResults)) {
 
FOR ($i = 0; $i < $columns; $i++) {
 
$out .='"'.$l["$i"].'",';
 
}
 
$out .="\n";
 
}
 
// Output to browser with appropriate mime type, you choose ;)
 
HEADER("Content-type: text/x-csv");
 
//header("Content-type: text/csv");
 
//header("Content-type: application/csv");
 
HEADER("Content-Disposition: attachment; filename=search_results.csv");
 
ECHO $out;
 
EXIT;
 
}