AliBail
Dec 9th, 2002, 11:18 AM
Ok, this was working last night, and nothing as far as I am aware has changed, but its not working today.
$query1 = mysql_list_dbs();
while ($databases = mysql_fetch_object($query1)) {
echo "<li><a href=?a=dview&db=".$databases->Database.">".$databases->Database."</a>\n";
$query2 = mysql_list_tables($databases->Database);
Basically, it returns the list of databases, but fails to return the tables, as query2 = Nothing!!
If anyone has any suggestions I would be greatfull.
$query1 = mysql_list_dbs();
while ($databases = mysql_fetch_object($query1)) {
echo "<li><a href=?a=dview&db=".$databases->Database.">".$databases->Database."</a>\n";
$query2 = mysql_list_tables($databases->Database);
Basically, it returns the list of databases, but fails to return the tables, as query2 = Nothing!!
If anyone has any suggestions I would be greatfull.