How to display column names in a mysql table using php

[skidmark10]

Hello,

 

Does anyone know the php code to display mysql table names?

[ebmigue]

You can query the INFORMATION_SCHEMA database, much like how you would query your own database.

 

Google "information_schema mysql".

 

Hope it helps.

[The Little Guy]

This will display each table on the page:

 

$sql = mysql_query("show tables");
while($row = mysql_fetch_array($sql)){
echo $row[0]."<br>";
}