note 44303 deleted from function.mysql-list-dbs by tomsommer
| From: | tomsommer@php.net | Date: | Tue, 20 Jul 2004 21:34:02 +0000 |
| Subject: | note 44303 deleted from function.mysql-list-dbs by tomsommer | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-73744@lists.php.net to get a copy of this message | ||
Note Submitter: skou at intern1 dot dk
----
You can also get a list of databases by using the sql query "SHOW DATABASES":
<?php
$query = "SHOW DATABASES";
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
$mysql_result = mysql_query($query, $link);
while ($row = mysql_fetch_row($mysql_result)) {
echo $row[0]."<br>\n";
}
?>