<HTML><HEAD><TITLE>SHOW TABLES</TITLE></HEAD><BODY>
<?php
mysql_connect("localhost", "root", "phpxphp") or die(mysql_error());
$q1 = mysql_query("show databases;");
$n1 = mysql_num_rows($q1);
echo "<UL>\n";
for ($i=0; $i < $n1; $i++) {
$r1 = mysql_result($q1, $i);
echo "<LI>".$r1."</LI>\n";
$q2 = mysql_query("show tables from $r1;");
$n2 = mysql_num_rows($q2);
echo "<UL>\n";
for ($j = 0; $j < $n2; $j++) {
$r2 = mysql_result($q2, $j);
echo "\t<LI>".$r2."</LI>\n";
$q3 = mysql_query("show fields from $r2 from $r1;");
$n3 = mysql_num_rows($q3);
echo "<UL>\n";
for ($k = 0; $k < $n3; $k++) {
$r3 = mysql_result($q3, $k);
echo "\t\t<LI>".$r3."</LI>\n";
}
echo "</UL>\n";
}
echo "</UL>\n";
}
echo "</UL>\n";
mysql_close();
?>
</BODY></HTML>
