// 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;
 
}