Displaying the column names of a table on a page

[ricardoramey]

I need to know on how to display on a page the column names of a table . By using Show is there a way to read that info and then to to display that info again? Or in a separate table can i store these info & the display these values?

I tested it but it is not working -

$result = mysql_query ("show columns from industries"); 

print ("<table>");
if ($row = mysql_fetch_array($result)) { 
do { 
print ("<tr><td bgcolor=#cccccc>");
print $row["field"]; 
print ("</td><td bgcolor=#cccc00>"); 
print $row["type"]; 
print ("</td><td bgcolor=#cccc00>"); 
print $row["null"]; 
print ("</tr>"); } 
while($row = mysql_fetch_array($result)); } 
else {print "Sorry, no records were found!";} 

print ("</table>");

Any help would be appreciated

[Gusgr8]

Have you seen the manual for these functions:

mysql_list_fields()
mysql_field_name()

[Expertz]

To show the fields you can use the SHOW FIELDS from {tablename} syntax, or keys to your arrays can be just used by you, cause they are keyed by the field names you wanna select. This is not exact but something like this will work.

$rs = mysql_query($some_sql); 
$printed_headers = false; 
echo "<table border=2>"; 

while ( $row = mysql_fetch_array($rs) ) 
{ 
    if ( !$printed_headers ) 
    { 
        //print the headers once: 
        echo "<tr>"; 
        foreach ( array_keys($row) AS $header ) 
        { 
            //you have integer keys as well as string keys because of the way PHP  
            //handles arrays. 
            if ( !is_int($header) ) 
            { 
                echo "<th>$header</th>"; 
            } 
        } 
        echo "</tr>"; 
        $printed_headers = true; 
    } 
     
    //print the data row 
    echo "<tr>"; 
    foreach ( $row AS $key=>$value ) 
    { 
        if ( !is_int($key) ) 
        { 
            echo "<td>$value</td>"; 
        } 
    } 
    echo "</tr>"; 
} 
echo "</table>"; 

[Team Leader]

//you have integer keys as well as string keys because of the way PHP  
       //handles arrays. 

You should use mysql_fetch_assoc() - http://www.php.net/mysql_fetch_assoc if you want to avoid the step caue you have numeric keys as you are getting the result through mysql_fetch_array() - http://www.php.net/mysql_fetch_array

[Expertz]

I think that something might be wrong in my example caue i had that problem with different version of the fetch commands. Nice tip Thanks & he can foolow up your method by removing both of the if ( !is_int() ) from my code that i made.