Viewing all available databases

PHP/Mysql

[slimcharlie]

Hi all, I am working on a PHP application that writes to many and different mysql dbs. I need users to be able to select which db to work on.

Is there any way (query) to display all the available db for the user to select one from a drop down or something?

I've been trying with:
Select * from master..sysdatabases with no luck.

Thanks for your help.

[mark_roach]

I think show databases does the trick.

[slimcharlie]

Could you be a little bit more specific?

Would it be something like
<?php
show databases
?>
?