Getting column names from MySQL query result

[beary]

I picked up the following code to take a mysql table to an excel file. What do I need to do to it to make the first excel row be the column names, rather than the first record?

$query  = "SELECT * FROM mytable";
$result = mysql_query($query) or die('Error, query failed');
 
$tsv  = array();
 
while($row = mysql_fetch_array($result, MYSQL_NUM))
{
   $tsv[]  = implode("\t", $row);
}
 
$tsv = implode("\r\n", $tsv);
 
$fileName = 'file.xls';
header("Content-type: application/vnd.ms-excel");
header("Content-Disposition: attachment; filename=$fileName");
 
echo $tsv;
 

[ronverdonk]

When you want to show the column names of your result, you have to use the mysql_field_name command. The following code snippet shows you how to display the column names of the result onmto the screen.

You can adapt it to your own choosing.

[php]
if (mysql_num_rows($result) > 0) {
$numfields = mysql_num_fields($result);
for ($i=0; $i < $numfields; $i++)
echo mysql_field_name($result, $i).'</br>';
}[/php]

Ronald :cool:

[beary]

Thanks Ronald.

When you want to show the column names of your result, you have to use the mysql_field_name command. The following code snippet shows you how to display the column names of the result onmto the screen.

You can adapt it to your own choosing.

[php]
if (mysql_num_rows($result) > 0) {
$numfields = mysql_num_fields($result);
for ($i=0; $i < $numfields; $i++)
echo mysql_field_name($result, $i).'</br>';
}[/php]

Ronald :cool:

[ronverdonk]

You are welcome. See you next time.

Ronald :cool: