working with 2 different databases

[Anon]

I have 2 different databases: db_1 , db_2

I need to switch between the 2 databases multiple times in the same script.

for example:

$result=mysql_query("insert into table set field='$field'");
$result_id = mysql_insert_id();

then i need to insert the result id into db_2

i could connect to the first db, then close it, then reconnect to the second db, then close it, then reconnect to the first db, but there must be a better way.

please help.

[bastien]

use pconnect to hold the connections open if you are hitting each DB multiple times, it will be quicker than re-establishing the conn each time...less server overhead as well.

hth

[Anon]

what about:

mysql_select_db("$database",$db);

i've tried this, but i don't think i'm using it correctly. shouldn't this be able to get me switched between 2 databases with the same connection?

[bastien]

that is correct. use pconnect to establish the connection and use the select_db() to change between the different Dbs

hth