Show all tables from database


$dbname="mydatabase";
$sql = "SHOW TABLES FROM $dbname";
$result = mysql_query($sql);

while ($row = mysql_fetch_row($result)) {
echo "
Found Table: {$row[0]}\n";
$alltables[]=$row[0];
}
var_dump($alltables);