Hi,

Is there a way to display 'field' names from a table when displaying mysql results?

yes. I am assuming you have fetched your data with php and the mysql_fetch_array functions. Then you just do a foreach loop;

foreach($retval as $key=>$value) {
echo "$key = $value<br />\n";
}

Where $retval is the variable which recieved the data from mysql_fetch_array.

Thanks webwoRRks,

So is $key a set variable to represent column headings?

At the moment I am using this loop to display my results:

PHP Code:

echo "<table width='340' border='1' 
cellpadding='4' cellspacing='0'>\n";
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) 
{
  echo "\t<tr>\n";
  foreach ($row as $col_value) 
  {
    echo "\t\t<td>$col_value</td>\n";
  }
  echo "\t</tr>\n";
}
echo "</table>\n"; 


How would I be able to incorporate the $key variable so that the field names would appear just once (at the top of the table)?

ah-hah, now we're talkin' (I just wanted to say that). Its nice and simple....

PHP Code:

<?php

echo "<table width='340' border='1' cellpadding='4' cellspacing='0'>\n";
$top = true;
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) 
{
    if($top) {
        echo "\t<tr>\n";
        foreach($row as $key=>$col_value) {
            echo "\t\t<td>$key</td>\n";
        }
        echo "\t</tr>\n";
        $top = false;
    }

  echo "\t<tr>\n"; 
  foreach ($row as $col_value) 
  { 
    echo "\t\t<td>$col_value</td>\n"; 
  } 
  echo "\t</tr>\n"; 
} 
echo "</table>\n";

?>

That's perfect.

Thanks so much for your help

no problem