Export mysql query to a text file

[brunholt]

Hi,

I want to export a mysql query to a txt or csv file.

I don´t have the permission to write on the mysql server so I can´t use the sql function "into outfile".

Can someone write me a thread with a php code that export the query in a file??? This would be great!!!

Thank you!!!

[barand]

This should do

$F = fopen('myfile.txt' , 'w');   // open for write
$delim = "\t";   // set delim, eg tab
$res = mysql_query("SELECT * FROM tablename");
while ($row = mysql_fetch_row($res)) {
    fwrite($F, join($delim, $row) . "\n");
}
fclose($F);

hth

[Duxie]

Hey barand!

Just wanted to say thanks for the code.

Mahalo Nui Loa
(Thank you very much, in Hawai'ian)