ouput query result to text file

[Anon]

Hey folks,
Have a problem.
I want to output the result of a sql query to a text file but i want each field to be seperated by a tabspace and each row to be marked by an end of line character.

Regards,
Kev.

[darrensw]

In your while loop you should take each field and seperate with \t and then use \n at the end of each line.

Should do the trick.

Darren

[Anon]

$iDBConn = mysql_connect(...);
mysql_select_db(\"dbname\", $iDBConn);
$strQuery = \"select.. \";
$rstList = mysql_query($strQuery, $iDBConn);

$fp = fopen(\"your-file_name.txt\", \"w\");
while ($row = mysql_fetch_array($rstList)) {
fwrite($fp, $row[\"fieldone\"].\"\t\");
fwrite($fp, $row[\"fieldtwo\"].\"\t\");
fwrite($fp, \"\n\");
}
fclose($fp);

havent tested, but that should be close

[Anon]

oh yea, ignore those extra backslashes, this board seems to escape them too many times..

i.e. \n should be just one slash instead of two