Another way to do this, if you'd like that names of the tables and, say, how many columns are in each table:
The information_schema database contains many useful tables that will give you the META-DATA about your databases and tables.
$sql = "SELECT TABLE_SCHEMA, TABLE_NAME, COUNT(*) AS columnCount "
. " FROM information_schema.COLUMNS "
. " GROUP BY TABLE_SCHEMA, TABLE_NAME "
. " ORDER BY TABLE_SCHEMA, TABLE_NAME ";
$results = mysql_query( $sql );
while($onetable = mysql_fetch_array($result))
$dbname = $onetable;
$tblname = $onetable;
$colcount = $onetable;
echo $dbname . ".`$tblname . "`: " . $tcount . " columns<br/>\n";