writing field names to file

Anon

I know I've asked about something similar in the past, but this time it's with a slight twist.

I need to write the field names of a particular database to a file. I understand how to echo the fields within an HTML/PHP page, but for this project I need to write them to a file. Here's what I have so far, which only seems to write the last field of the database to the file.

<?
$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);
?>

Any and all help is always appreciated.

Anon

All you have to do is call fopen before your for() loop and put the fwrite inside the loop.

Anon

kick ass. that worked. now I just need to figure out a way to format it so it's not:

fieldname1
fieldname2
fieldname3

but rather:

fieldname1,fieldname2,fieldname3

Anon

for ($i = 0; $i < $columns; $i++) {
$fieldnames[] = mysql_field_name($fields, $i);
}
$csv = fopen("/path/to/file.csv", "w");
fwrite($csv, implode(",", "$fieldnames));
fclose($csv);

Anon

Actually, I just removed the \r\n and it puts them all out on the same line, comma deliminated:

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

I have the field names now listed as such:

filedname1,fieldname2,fieldname3

As it stands, I'm now working on a break after the field names, and having the rest of my data listed in a separate section.

Basically it's going to look similar to this:

fieldname1,fieldname2,fieldname3
data1,data2,data3
data2.1,data2.2,data2.3

The only problem is, now I have the first line of data immediately after the fieldnames:

fieldname1,fieldname2,fieldname3,data1,data2,data3
data2.1,data2.2,data2.3
data3.1,data3.2,data3.3

make sense?

I've added a \n to the beginning of my second write to the file, but this only double spaced the data results:

fieldname1,fieldname2,fieldname3
data1,data2,data3

data2.1,data2.2,data2.3

data3.1,data3.2,data3.3

sooooo... I'm trying to figure out a way to have one single break after the field names, and then the data starts.

I know this seems confusing, and I really do appreciate all your help with this, even though I know it seems simple to most, I appear to be struggling.