[SOLVED] Calling from one database to another

[wookie]

I've got a forum and gallery software each with their own mysql database on the same host. If I want to call info from the galleries database to be used in the forum, from within the forum itself, how would I do this?

 

Do I need to specify database user and pass similar to this:

 

$dbuser="####";
$dbpass="####";
$dbname="####";
$chandle = mysql_connect("localhost", $dbuser, $dbpass) 
    or die("Connection Failure to Database");

 

Or is there a simpler way to achieve this?

 

Many thanks

 

Wookie.

[trq]

No, you just need to use mysql_select_db to switch between the different databases using the same connection.

[wookie]

Gotcha...thanks a lot. I thought it would be something simple.

 

Wookie.