how To connet to 2 databases.

[Anon]

Hi, I was wander how can I connect to two databases from my program.

when I call

$link1=mysql_pconnect(localhost,$DB_LOGIN,$DB_PASSWORD)

$link2=mysql_connect("localhost","t","t")))

mysql_select_db("DATBAS1",$link1))
mysql_select_db("DATASE2",$link2))

mysql_query("$SQLStm",$link1)
mysql_query("$SQLStm",$link2)

Both function with $link1 resultset point to the $link2 result set for some reason.

If I want to be able to access 2 database from my program how do I do it. It seems that the leset mysql_select_db() call with $link2 overrides existing $link1.

How do I overcome this problem.

Thank,

Roman

[Anon]

first select the database do your query and then go to the next database

sorta like this:
mysql_select_db("DATBAS1",$link1))
mysql_query("$SQLStm",$link1)

mysql_select_db("DATASE2",$link2))
mysql_query("$SQLStm",$link2)

hope this helps,
stef

[Anon]

i would have thought his code would work. if mysql only recognizes one connection, then why does it have the optional link arguement on the mysql_query function??