Table of Contents for

MySQL in a Nutshell, 2nd Edition

This function returns the name of the database from the results of the mysql_list_dbs() function, which returns a pointer to a results set containing the names of databases for a MySQL server. The reference to the list of databases is given as the first argument. A number identifying the row to retrieve from the list is given as the second argument. Here is an example:

...
$databases = mysql_list_dbs( );
$dbs = mysql_num_rows($databases);
for($index = 0; $index < $dbs; $index++) {
    print mysql_db_name($databases, $index) . "\n";
}
...

In this script excerpt, a results set containing a list of databases is retrieved and stored in the $databases variable using the mysql_list_dbs() function. That results set is analyzed by mysql_num_rows() to determine the number of records (i.e., the number of database names) that it contains. Using a for statement and the number of databases ($dbs), the script loops through the results set contained in $databases. With each pass, mysql_db_name() extracts the name of each database by changing the second argument of the function as the value of $index increments from 0 to the value of $dbs.