[SOLVED] Listing Table Names.. Please Help

[eugene2009]

Hey, is it possible to list all the table names in a database on an html page?

 

For example:

 

Database Name: Cars

 

Table Names:

 

-BMW

-Mercedes

-Volkswagen

-Ford

-Volvo

 

How do I have it generate that list automatically if I add new tables later on?

[cags]

Once the database is selected...

 

$result = mysql_query("SHOW TABLES");

echo '<ul>';
while($row = mysql_fetch_array($result)) {
   echo '<li>' . $row[0] . '</li>';
}
echo '</ul>';

[eugene2009]

THANK YOU!!!

[eugene2009]

is it possible to show tables from 2 databases in one list..

 

how would i make this work????

 

mysql_select_db ([color=red][b]test, blog[/b][/color]);

$result = mysql_query("SHOW TABLES");

echo '<ul>';
while($row = mysql_fetch_array($result)) {
   echo '<li>' . $row[0] . '</li>';
}
echo '</ul>';

[eugene2009]

 

sorrryy exclude the font formatting..

 

 

mysql_select_db (test, blog);

$result = mysql_query("SHOW TABLES");

echo '<ul>';
while($row = mysql_fetch_array($result)) {
   echo '<li>' . $row[0] . '</li>';
}
echo '</ul>';

[cags]

I believe the SHOW TABLES has a FROM syntax, not tested it but I'd try something like...

 

mysql_query("SHOW TABLES FROM db1, db2");

[eugene2009]

doesnt work.. im pretty sure there needs to be somthing in this line:

 

mysql_select_db (test, blog);

 

thanks in advance

[cags]

I don't believe you can select multiple tables like that, but you should be able to do this...

 

echo '<ul>';
$result = mysql_query("SHOW TABLES FROM table1");
while($row = mysql_fetch_array($result)) {
   echo '<li>' . $row[0] . '</li>';
}
$result = mysql_query("SHOW TABLES FROM table2");
while($row = mysql_fetch_array($result)) {
   echo '<li>' . $row[0] . '</li>';
}
echo '</ul>';