Do a select on mysql's system database/table Mysql.db
There's a column called db and one called user. Put a where clause on user. If you want more help, there is a PHP-DB mailing list. [TK] > -----Original Message----- > From: jtjohnston [mailto:[EMAIL PROTECTED]] > Sent: Thursday, 7 March 2002 3:31 PM > To: [EMAIL PROTECTED] > Subject: [PHP] $db_list = mysql_list_dbs > > > mysql-list-dbs works but displays all databases. How do I > limit to display those that a user has access rights to? > http://www.php.net/manual/en/function.mysql-list-dbs.php $link = mysql_connect($server, $user, $password); $db_list = mysql_list_dbs($link); while ($row = mysql_fetch_object($db_list)) { echo $row->Database . "\n"; } -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
