sending a query result to a text file

[Anon]

hey,
I've this query that I run and I send the result to a text.txt file. The result is being sent allright but I need to put the field names on the first line of the text file.
i want it like this on the first line before the rest of the stuff:
name|address|phone|blah|blah|blah|

how can I do this??

Rooin.

[Anon]

Do you know which fields are being written? In MySQL at least you can get a resultset containing a table's field names using mysql_list_fields()

http://www.php.net/mysql_list_fields

You can build up an $array of the fields you want represented and then go $firstline=join('|',$array) to provide you with the first line. Oh, and a $firstline.="|\n"; to get that last | and a newline.

Then you proceed to write the rest of the file.