Exporting to csv

[Dogbreath]

Please help, i need to export sql results to a browse window so that users can save the sql search results into a csv file for a mail merge

http://www.phpbuilder.com/board/showthread.php?s=&threadid=10235031

[RedDragon]

well if i remember right a csv file is build up the following:

"fieldnamea","text","4"
"b","another","4"
"c","bla","3"

$dump="";
$result = $db->query("SELECT * FROM ".$table);
while($row = $db->fetch_array($result)) {
   $dump .= "\"$table\",";
   $z=0;
   foreach($row as $x=>$y) {
      $y = addslashes($y);
      if($z==sizeof($row)-1) {
         $dump .= "\"$y\"\n";
      } else {
         $dump .= "\"$y\",";
      }
      $z++;
   }
}

then you need to set all headers and echo the data, eg:

header('Content-Type: ' . $mime_type);
header('Content-Length: ' . strlen($dump));
header('Content-Disposition: inline; filename='filename"');
header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
header('Pragma: public');
echo $dump;