Enumerate MySQL Databases etc.

[jtmerchant]

Is there any way to enumerate the databases and tables with PHP?

[edcellgavin]

try these queries

$result = mysql_query('show databases', $link);
// loop result

and

mysql_select_db('db_name', $link);
$result = mysql_query('show tables', $link);
// loop result

[jtmerchant]

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in C:\PHP Site\test.php on line 34

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in C:\PHP Site\test.php on line 35

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in C:\PHP Site\test.php on line 38

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in C:\PHP Site\test.php on line 39

line 34: $result = mysql_query('show database', $link);
line 35: echo mysql_result($result,0);
line 36: 
line 37: @mysql_select_db($database) or die( "Unable to select database");
line 38: $result = mysql_query('show tables', $link);
line 39: echo mysql_result($result,0);

Is the way I'm echoing the result incorrect or what?

[liquorvicar]

$result = mysql_query('show databases', $link);

note the plural.

[jtmerchant]

Hmm. Ok, these work:

@mysql_select_db($database) or die( "Unable to select database");
$result = mysql_query("SHOW TABLES");
while($row = mysql_fetch_row($result)) {
echo "{$row[0]} <BR>\n";
}
//---------------
$result = mysql_query("SHOW DATABASES");
while($row = mysql_fetch_assoc($result)) {
echo "{$row["Database"]} <BR>\n";
}

But why doesnt this?

$result = mysql_query("SHOW TABLES");
while($row = mysql_fetch_assoc($result)) {
echo "{$row["Table"]} <BR>\n";
}

What should I put in $row[(here that is)]?

[edcellgavin]

$row['tables_in_dbname'];