|
Well, I would guess there are quite a few ways to do this - personally, the way I have always done it is by using SQL.
From looking on the internet, an SQL statement like :
SELECT table_name FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = 'db_name' (where db_name is changed to become your database name)
should give a result.
In PHP (after opening the DB etc.) I would have something like:
$c_result = mysql_connect("localhost", "user", "pass");
$s_result = mysql_select_db("database", $c_result);
$SQLQuery ="SELECT table_name FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = 'db_name'";
$q_result = mysql_query($SQLQuery, $c_result);
$numrows = mysql_num_rows($q_result);
for ($rownum=0; $rownum < $numrows; $rownum++)
{
$myname= mysql_result($q_result, $rownum,"table_name");
print $myname;
}
Something like that - its just a guestimate, so you will have to play around with it to get it working properly
|
