Php/Mysql Help-Getting Databases

[Kura_kai]

Is there a command that returns in a array all of the databases? If not something similiar to getting databases.

[Tangerine Dream]

Hi, if you want a list of databases, you need SHOW DATABASES (http://dev.mysql.com/doc/mysql/en/show-databases.html) statement that returns DB names in 'Database' column

[Kura_kai]

Sorry forgot to tell you though title showed it. But i want it to be a php command. sorry

[Tangerine Dream]

Check PHP manual' mysql_query (http://www.php.net/manual/en/function.mysql-query.php) topic or any other MySQL related tutorials for examples, i.e just replace SQL statement like "SELECT * FROM ... WHERE ...." with "SHOW DATABASES" and use appropriate mysql_fetch_xxxx (http://www.php.net/manual/en/ref.mysql.php) function to get values of 'Database' column. Now, this thread is about PHP :)

[Kura_kai]

ok if possible can someone give me a sample script not sure what you are talking about.