MySQL

How to connect to two databases at the same time

Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Apr 2008

Posts: 109

Reputation: architact is an unknown quantity at this point

Solved Threads: 7

architact

Offline

Junior Poster

How to connect to two databases at the same time

Mar 19th, 2009

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

If you think we fight for money and you fight for honor, then remember everyone fights for the thing they don't have...

•

Join Date: Jan 2007

Posts: 101

Reputation: PirateTUX is an unknown quantity at this point

Solved Threads: 3

PirateTUX

Offline

Junior Poster

Re: How to connect to two databases at the same time

Mar 19th, 2009

What language are you using?

WolfWorkz Studios - Server Development
WolfWorkz.com
Pirates Registration
My Personal Blog
SideBySideGeek.com - My Newest Project

•

Join Date: Apr 2008

Posts: 109

Reputation: architact is an unknown quantity at this point

Solved Threads: 7

architact

Offline

Junior Poster

Re: How to connect to two databases at the same time

Mar 19th, 2009

php/mysql

If you think we fight for money and you fight for honor, then remember everyone fights for the thing they don't have...

•

Join Date: Dec 2007

Posts: 190

Reputation: mwasif is an unknown quantity at this point

Solved Threads: 25

mwasif

Offline

Junior Poster

Re: How to connect to two databases at the same time

Mar 19th, 2009

Are you using link identifier with mysql_query()?

•

Join Date: Nov 2007

Posts: 3,749

Reputation: nav33n is a jewel in the rough

Solved Threads: 331

nav33n

Offline

Senior Poster

Re: How to connect to two databases at the same time

Mar 19th, 2009

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

Ignorance is definitely not bliss!

*PM asking for help will be ignored*

•

Join Date: Apr 2009

Posts: 4

Reputation: abhi211285 is an unknown quantity at this point

Solved Threads: 1

abhi211285 abhi211285 is offline

Offline

Newbie Poster

Re: How to connect to two databases at the same time

Jul 24th, 2009

•

Originally Posted by 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

This help you out..

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
$link=mysql_connect("localhost", "name", "password", true);
$link1=mysql_connect("localhost", "name", "password", true);
 
$mysql_query($qry,$link);
$mysql_query($qry1,$link1);
$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.

Last edited by peter_budo; Jul 24th, 2009 at 3:03 pm. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.

Abhishek Joshi
IT-Analyst