Multiple database + pconnect issues

[eluser]Seppo[/eluser]
I've thought about that...
Even if the hostname is the same, the username and password must match, and the connection must be a persistent connection to require that step... I thought to do it in all cases, 'cause it won't hurt anyone to call mysql_select_db if it's already selected...

But if we want to do it, maybe we can use

Code:

<?php
function db_select()
{
    static $selected_db = array();

    // If it's a persistent connection we will keep a track on the selected db
    if ($this->db->pconnect === TRUE)
    {
        // Unique key per permanent connection
        $key = serialize(array($this->hostname, $this->username, $this->password));
        if (array_key_exists($key, $selected_db) && $selected_db[$key] == $this->database) {
            return TRUE;
        }
        $selected_db[$key] = $this->database;
    }

    return @mysql_select_db($this->database, $this->conn_id);

}
?>