connecting to two databases

[darthmahon]

Hi,

Just wondering if it's possible to have a connection open to two databases at one time?

I want to send mass emails to all registered users of a site I am making, but there is a database that stores all the user information and one that stores other things such as files, images etc. So I need to be able to select data from both databases.

I've tried using the following but it's not working:

$conn = mysql_connect ($SQLhost, $SQLuser, $SQLpass);
$dbselect = mysql_select_db ($SQLdb);

$conn2 = mysql_connect ($sql_host, $sql_user, $sql_password);
$dbselect2 = mysql_select_db ($sql_db);

Any ideas?

Cheers,
Chris

[laserlight]

$conn = mysql_connect ($SQLhost, $SQLuser, $SQLpass);
$dbselect = mysql_select_db ($SQLdb, $conn);

$conn2 = mysql_connect ($sql_host, $sql_user, $sql_password);
$dbselect2 = mysql_select_db ($sql_db, $conn2);

Likewise for queries,
mysql_query(QUERY, $conn);