PHP/mySQL, get column headers?

[Mick White]

IS it possible in PHP to grab the headers following a mySQL query?

SELECT [headings] from tablename.

I'm looking for a generic PHP function that will include the headings,
so that I can display a meaningful table.

Mick

[Chris Hope]

Mick White wrote:

IS it possible in PHP to grab the headers following a mySQL query?

SELECT [headings] from tablename.

I'm looking for a generic PHP function that will include the headings,
so that I can display a meaningful table.

If you use mysql_fetch_ass oc() or mysql_fetch_arr ay() with MYSQL_ASSOC
as the 2nd parameter then you'll get an array indexed with the column
names.

For example:

$res = mysql_query('se lect a, b, c from foo');
$row = mysql_fetch_ass oc($res);
print '<table><tr>';
foreach($row as $name => $value) {
print "<th>$name</th>";
}
print '</tr>';
while($row) {
print '<tr>';
foreach($row as $value) {
print "<td>$value </td>";
}
print '</tr>';
$row = mysql_fetch_ass oc($res);
}
print '</table>';

http://www.php.net/mysql_fetch_assoc
http://www.php.net/mysql_fetch_array

You can also use the mysql_fetch_fie ld() and mysql_field_nam e()
functions.

for($i = 0; $i < mysql_num_field s($res); $i++) {
print '<th>' . mysql_field_nam e($res, $i) . '</th>';
}

http://www.php.net/mysql_fetch_field
http://www.php.net/mysql_field_name
http://www.php.net/mysql_num_fields(

--
Chris Hope - The Electric Toolbox - http://www.electrictoolbox.com/

[Jan Pieter Kunst]

Mick White wrote:

IS it possible in PHP to grab the headers following a mySQL query?

SELECT [headings] from tablename.

I'm looking for a generic PHP function that will include the headings,
so that I can display a meaningful table.

Mick

<http://nl.php.net/manual/en/function.mysql-list-fields.php>

JP

--
Sorry, <de*****@cauce. org> is a spam trap.
Real e-mail address unavailable. 5000+ spams per month.

[News Me]

Mick White wrote:

IS it possible in PHP to grab the headers following a mySQL query?

SELECT [headings] from tablename.

I'm looking for a generic PHP function that will include the headings,
so that I can display a meaningful table.

Mick

DESCRIBE TABLE <tablename>

NM

[Mick White]

Chris Hope wrote:

Mick White wrote:

IS it possible in PHP to grab the headers following a mySQL query?

If you use mysql_fetch_ass oc() or mysql_fetch_arr ay() with MYSQL_ASSOC
as the 2nd parameter then you'll get an array indexed with the column
names.

For example:

$res = mysql_query('se lect a, b, c from foo');
$row = mysql_fetch_ass oc($res);
print '<table><tr>';
foreach($row as $name => $value) {
print "<th>$name</th>";
}
print '</tr>';
while($row) {
print '<tr>';
foreach($row as $value) {
print "<td>$value </td>";
}
print '</tr>';
$row = mysql_fetch_ass oc($res);
}
print '</table>';

http://www.php.net/mysql_fetch_assoc
http://www.php.net/mysql_fetch_array

You can also use the mysql_fetch_fie ld() and mysql_field_nam e()
functions.

for($i = 0; $i < mysql_num_field s($res); $i++) {
print '<th>' . mysql_field_nam e($res, $i) . '</th>';
}

http://www.php.net/mysql_fetch_field
http://www.php.net/mysql_field_name
http://www.php.net/mysql_num_fields(

Thanks, Chris (and others), that did the trick.
Mick