[Resolved] [Resolved] export mysql query to csv file help

[sofasurfer]

Hi!

what I need to do, seems not to be difficult:

I have a mysql query, and iI need tha when the user clicks a link, that result of the query be transformed into a csv file, for the user to download
example: <a>download here your query</a>

question: how do I do that? can someone show me an example?

here is one of my queries:

mysql_select_db($database_liga, $liga);
$query_rsTrial = "SELECT users.email FROM users WHERE (users.todas = 's') OR (users.trial = 's') ORDER BY users.email";
$rsTrial = mysql_query($query_rsTrial, $liga) or die(mysql_error());
$row_rsTrial = mysql_fetch_assoc($rsTrial);
$totalRows_rsTrial = mysql_num_rows($rsTrial);

I know I have to insert headers somewhere... where?

many thx in advance

[wilku]

Your link should point to a php script in which:

<?php//this should be the first line
header('Content-type: application/msexcel');
header("Content-disposition: inline; filename=\"test.csv\"");
header("Pragma: no-cache");
header("Expires: 0");

//do your query

//foreach row
$row = "";
//    foreach field
                $row.=$field.", ";
//end foreach field
echo rtrim($row,", ")."\n";
//end foreach row  

?>

[jansky]

this is what you need
1. create a filename for your csv like myexcel.csv using
fopen() function and a parameter of w+
2. in your query
one variable is enough like
$myvalue="";
while (yourquery ())
{
$myvalue .=$yourfield."\n"; / \n -- present next line /
/* to add more field in your csv file just add "," after your field
}
3. then do the function fwrite here

4. since this is CSV file you can redirect to the page like
   http://www.domain.com/myexcel.csv
   and auto download will do

5. now you have now your csv file