CSV again

[thoand]

I am trying to export my MySQL data to an CSV file,

the procedure I use is quite simple:

connects to the databaseserver
select database
get all the data in a select

loop and place everything in a variable eg $content

$content .= $data[rname].";".$data[rfirm].";".$data[rtitle].";".$data[radress].";".$data[rpostalcode].";".$data[rregion].";".$data[rphone].";".$data[remail].";".$data[rtype]."\n";

and then write $content to a file.

but to put all the values into $content seems to take forever
is there a better way to do this?

regards Thomas A.

[mystrymaster]

couldn't you simply export the data from the table instead of though something like phpMyAdmin or something?

[ajmoore]

Why not just write the file line by line in your while loop?

$result = mysql_query("SELECT * FROM table");
$fp = fopen("filename.csv","w+");
while($row = mysql_fetch_array($result)) {
     $line = $row["field1"] . "," . $row["field2"] . "," . $row["field3"];
     fputs($fp,$line,strlen($line));
}
fclose($fp);

That should cycle through the results and output each line to your file..

[The_Chancer]

You can use the SQL statement of SELECT INTO OUTFILE which can make a csv for you....

See http://www.mysql.com/doc/en/SELECT.html Which should help..