[SOLVED] Connecting to two databases at the same time.

[JSHINER]

I have the following:

 

function List($db, $zip = false) {

$db->selectDb('database2');

$town = $db->getRow("SELECT * FROM towns_zipcodes, towns WHERE town_zipcodes.zip = '$zip' AND towns_zipcodes.town_id = towns_zipcodes.zip AND towns.id = towns_zipcodes.towns_id AND towns.id = towns.name LIMIT 1");

return $town;

}

 

The page this is for is connected to database1, but I need to query databse2 to get these results.

 

What is the correct way to query another database while connected to database1?

[JSHINER]

And ideas?

[tauchai83]

i never try that before. But why you want to connect to 2 DB at once? 1 DB stores many tables which is good enough.

 

to connect DB, we need to establish connection. So if you want 2 DB, you are likely to need to make connection to DB twice. but this is not encouragable. Using one DB and have many tables inside is good enough.

 

tell me the reason you want 2 DB. Thanks.

[fert]

what are you using to connect to the databases?

[JSHINER]

I need to connect to two because one has a lot of tables, and so does the second. And they are used for different things.

 

To connect to the first I use the standard mysql_connect. However, while under that connection, I need to open a new connection to retrieve data to display on the same page. I tried using mysql_select_db but it did not work.

 

Any suggestions?

[fert]

$cn1=mysql_connect("host","user","password");
$cn2=mysql_connect("Host","user","password");

mysql_select_db("db1",$cn1);
mysql_select_db("db2",$cn2);