[SOLVED] get the name of the column from a SQL database ?

[lonewolf217]

Not sure if this is possible or not.  I am trying to consolidate code over several pages, all of which have similar queries where they gather data from a database and then output it to a table.  The main reason right now why they are on separate pages is because the column headers for each of the tables is different, so i was wondering if there was any way i could programmatically get the name of the column in SQL to display ?

[Psycho]

mysql_fetch_field()

 

http://us.php.net/manual/en/function.mysql-fetch-field.php

[sasa]

or

<?php
$result = mysql_query('SELECT * FROM table_name');
$row = mysql_fetch_assoc($result);
echo '<table><tr><td>'.implode('</td><td>', array_keys($row))."</td></tr>\n";
do {
echo '<tr><td>'.implode('</td><td>',$row)."</td></tr>\n";
}while ($row = mysql_fetch_assoc($result));
echo "</table>\n";
?>

[lonewolf217]

thanks, ill play around with it to see if i can get it to work out