Simple SQL connecting to 2 databases at same time

[johnsmith153]

This is what I need to do (connect to two databases at same time)

 

$con1 = mysql_connect("server", "user", "pass");
if (!$con1)
{
echo "Could not connect to db 1: ". mysql_error();
exit;
}

//connect to db 2
$con2 = mysql_connect("server", "user", "pass");
if (!$con2)
{
echo "Could not connect to db 2: ". mysql_error();
exit;
}


//select db 1
mysql_select_db("dbase-name", $con1);

 

The problem is the above will not work - it doesn't select the first connection again - as though it has been lost.

 

However if I check if($con1) it DOES exist.

 

If I tried to perform queries on connection 2 - this would work.

[JonnoTheDev]

Are the databases on the same server. You dont have to open 2 connections if so, you can prepend the table name with the database name:

mysql_query("SELECT * FROM db1.tablename ",$conn);
mysql_query("SELECT * FROM db2.tablename ",$conn);

Just dont use mysql_select_db()

[johnsmith153]

They are not on the same server

[JonnoTheDev]

Try persistent connections

$db1 = mysql_pconnect($host,$user,$pass);
$db2 = mysql_pconnect($host,$user,$pass);
mysql_select_db("db1",$db1);
mysql_select_db("db2",$db2);

[johnsmith153]

I prefer not to use persistent connections. is there another way?

[johnsmith153]

Ensure every mysql function also has the exact resource specified.

 

ie: $mysqlRes = mysql_query($sql,$con1);

 

as: $mysqlRes = mysql_query($sql); may cause problems when using multiple connections

[lostnucleus]

by very its nature mysql_connect uses only one connection at a time to save resources  , try to close the first connection b4 using another or use

 

$conn1 = new mysqli($host,$username,$password,$databasename);

 

$result = $conn->query('select.....');

 

$conn2 = new mysqli($host2,$username2,$password2,$databasename2);

$result2 = $conn2->query('select.....');

 

for this make sure mysqli extension is loaded ....