HTML Database listing

[cdpettet]

I am using Apache 2 to run a web site and I need to know what the PHP MySQL command is for listing databases.

What I am intending to do is, once connected to the server, list all the databases for administration. The user then clicks the relevant database link to attach to and can then carry out the administration.

With MySQL it's easy, you just use SHOW databases. However, how does this get translated into PHP?

I am running MySQL 3.23.55 on Windows XP with PHP version 4.3.1.

Any help gladly received.

 

[danielhozac]

[tt]mysql_list_dbs()[/tt] should do what you want.

http://www.php.net/manual/en/function.mysql-list-dbs.php

Note that there is a PHP forum here on Tek-Tips: Forum434. //Daniel

 

[cdpettet]

Thanks for that - I'll check it out.