How to connect to two databases at the same time

[architact]

Hello Guys I want to connect two databases at the same time but it looks like the php is only picking up the second database.

One database is on my localhost and the other one is on server, I want to transfer the data from my localhost database to the database on the server. I have also tried passing the 4th argument to the mysql_connect function but I can't get it to work.
mysql_connect("localhost", "name", "password", true);

Please help me.

Thanks

[PirateTUX]

What language are you using?

[architact]

php/mysql

[mwasif]

Are you using link identifier with mysql_query()?

[nav33n]

http://in.php.net/mysql_select_db Read the comments, especially of buzz at oska dot com :)

[abhi211285]

Hello Guys I want to connect two databases at the same time but it looks like the php is only picking up the second database.

One database is on my localhost and the other one is on server, I want to transfer the data from my localhost database to the database on the server. I have also tried passing the 4th argument to the mysql_connect function but I can't get it to work. mysql_connect("localhost", "name", "password", true);

Please help me.

Thanks

This help you out..

$link=mysql_connect("localhost", "name", "password", true);
$link1=mysql_connect("localhost", "name", "password", true);

$mysql_query($qry,$link);
$mysql_query($qry1,$link1);

This the one.

[vamsy143]

In mysql how can I connect two databases..