Print All MySQL Database Tables & Fields Using PHP
" . $row['0'] . " "; $i = 0; $loop2 = mysql_query("SHOW columns FROM " . $row[0]) or die ('cannot select table fields'); while ($row2 = mysql_fetch_array($loop2)) { echo " Field Type Key Default Extra "; $i++; } echo " " . $row2[0] . " " . $row2[1] . " " . $row2[2] . " " . $row2[3] . " " . $row2[4] . "
"; } ?>