More than one connection into the same script

[cubax]

Hello,
I'm using Mysql and I'm facing a problem...

I have to manage 2 different connection to 2 different databases in the same script...

Something like this:

//Get datas from staging
$connect_staging = mysql_connect ($host, $user, $password) or die ("Impossibile connettersi al DB");
mysql_select_db ($db_staging, $connect_staging) or die ("Impossibile selezionare il db $db_staging");

//Get datas from production
$connect_production = mysql_connect ($host, $user, $password) or die ("Impossibile connettersi al DB");
mysql_select_db ($db_production, $connect_production) or die ("Impossibile selezionare il db $db_production");

Now, if I put my mysql query at this point all my outputs will be always related to second connection... Even if I call specific values related to the first one....

How it has to be done?

I need to connect to the 2 DBs and manage in the same script the related outputs.

Thanks!

[ThreeDee]

You can specify which connection to use when you call the mysql_query() function. See for yourself:

http://www.php.net/manual/en/function.mysql-query.php