listing specific table fields

[Anon]

Greetings,

I have a piece of code that I have been using which dumps all the fields of a specified table into a csv file. See code:

$link = mysql_connect('localhost', 'user', 'pass');
$fields = mysql_list_fields("db", "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);

What I am needing now, is specific field names, not all of them. Is there a way to force the list fields function to only list specific fields?

Any help is greatly appreciated.

[[deleted]]

uhm.. if you already know which fields you want to list, then why are you using the list_fields function?

[Anon]

heh. I went back and re-thought out my logic. I came to this conclusion and used a different function. The end results do exactly what I want it to. Here's what I did for all that want to know:

<?
$link = mysql_connect('localhost', 'user', 'pass');
$res = mysql_db_query("db", "select * from table", $link);
$csv = fopen("/path/to/file.csv", "w");
$fieldname = mysql_field_name($res, 1);
$fieldname2 = mysql_field_name($res, 2);
$fieldname3 = mysql_field_name($res, 8);
fwrite($csv,"$fieldname,$fieldname2,$fieldname3,");
fclose($csv);
?>

This code writes out the second, third and seventh field of the table to a CSV file for later exportation.