PHP SHOW DATABASES

[schutzy]

Hello All,

I am (attempting to write) writing an admin web interface for a CMS and as usual my first hurdle that I have to jump appears on the first line of real code...:(

The admin's function is to allow simple database management for multiple mysql databases via a browser. The issue that I am having right now is that I am trying to retrieve the names of all of the mysql databases that have been created. Using the command line this is a simple SHOW DATABASE; However, the mysql_query doesn't return any values.

Here's the code:

$dbquery = mysql_query("SHOW DATABASES;");
$i = 0;
while ($row = mysql_fetch_assoc($dbquery)) {
$arr[$i] = $row['post_title'];
echo "<br> $i=$arr[$i]";
$i++ ;
}

This is probably a stupid post but what the heck

Schutzy

[Crimpage]

Change

$arr[$i] = $row['post_title'];

to

$arr[$i] = $row['Database'];

Otherwise, I just copied and pasted your code and all worked fine.

[Prismatic]

This works for me, returns all the databases on the server...

[code]
$dbquery = mysql_query("SHOW DATABASES");

$i = 0;
while ($row = mysql_fetch_assoc($dbquery)) {
    $arr[$i] = $row['Database'];
    echo "<br> ". $i ." = " .$arr[$i];
    $i++;
}
[/code]

[schutzy]

Thanks All!

I'm testing it right now...


Schutzy