Show Fields

#!/usr/bin/php
<?php
mysql_connect(“localhost”, “root”, “phpxphp”);
$q1 = mysql_query(“show databases;”);
$n1 = mysql_num_rows($q1);
for ($i; $i < $n1; $i++) {
$r1 = mysql_result($q1, $i);
echo $r1.”\n”;$q2 = mysql_query(“show tables from $r1;”);
$n2 = mysql_num_rows($q2);
for ($j = 0; $j < $n2; $j++) {
$r2 = mysql_result($q2, $j);
echo “\t”.$r2.”\n”;$q3 = mysql_query(“show fields from $r2 from $r1;”);
$n3 = mysql_num_rows($q3);
for ($k = 0; $k < $n3; $k++) {
$r3 = mysql_result($q3, $k);
echo “\t\t”.$r3.”\n”;
}
}
echo “\n”;
}
mysql_close();
php?>