PDA

Click to See Complete Forum and Search --> : Anoying mySQL Problem


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.

phpman
Dec 10th, 2002, 01:54 PM
code doesn't work then stop working for nothing. apparently the server changed or died.

try using fetch_array instead