Field names exported

[Anon]

Greetings,

Time for another round of twenty questions..heh. I need to know how to get the field names as well as the data therein to export to a file with the data.

If you've seen some of my previous posts, you will have noticed that I am now able to run my SQL query, get the data, and write that data to a .csv file for later importation into such applications as Excel. I would also like the field headers written to the file as well. Any quick way to do this? Any help is appreciated!

[Anon]

http://www.php.net/manual/en/function.mysql-field-name.php
or
http://www.php.net/manual/en/function.mysql-list-fields.php

[Anon]

This helped me with printing out the field names, but I need the field names written to a file. Not quite sure how I'd go about doing that.

<?
$link = mysql_connect('localhost', 'user', 'pass');
$fields = mysql_list_fields("db", "table", $link);
$columns = mysql_num_fields($fields);
for ($i = 0; $i < $columns; $i++) {
$fieldnames = mysql_field_name($fields, $i) . "\n";;
}
$csv = fopen("/path/to/file.csv", "w");
fwrite($csv,"$fieldnames\r\n");
fclose($csv);
?>

That only seems to write the last fieldname to the file. =[