Retrieving a lot of records to a file

[arkman]

I'm trying to query a remote MYSQL server via PHP and retreive a pretty large record set which I then need to write out to a file. My problem is that the query, or more likely, the writing to a file seems to just die. Below is my code, but I'm oretty sure there must be a better way to do this!?! I'm trying to return 100K rows!

//the query
$result = mysql_query("SELECT 1,2,3,4,5 FROM product");

while($row = mysql_fetch_array($result)) {
$csv_output .= "$row[1]\t$row[2]\t$row[3]\t$row[4]\t$row[5]\n";
$csv_output .= "\015\012";
//write out the results to a file
$handle=fopen($filename, 'w+');
fwrite($handle, $csv_output);
fclose($handle);
}

Thanks.

[devinemke]

you appear to be trying to write a tab delimited text file. if so you should just use mysqldump.

[arkman]

Thanks. I have other issues keeping me from using mysqldump remotely. I had some errors in my php there, so I've changed it to the following:

$handle=fopen($filename, 'w+');

//the query
$result = mysql_query("SELECT 1,2,3,4,5 FROM product");

while($row = mysql_fetch_array($result)) {

//write out the results to a file
fwrite($handle, "$row[1]\t$row[2]\t$row[3]\t$row[4]\t$row[5]\n");
}

fclose($handle);