Ad:

MySQL Discussion Thread
Unsolved
Views: 5573

Mar 19th, 2009

How to connect to two databases at the same time

Expand Post »

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

Similar Threads

Connecting C++ to MS-Access in C++
Multi-user program issues in VB.NET
Custom Database Admin Tool. in PHP
i`m lost!!! in PHP
Hardware Interrupts & 100% CPU usage in Windows NT / 2000 / XP

architact

Reputation Points: 40

Solved Threads: 7

Junior Poster

Offline

114 posts
since Apr 2008

Permalink

Mar 19th, 2009

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

What language are you using?

PirateTUX

Reputation Points: 17

Solved Threads: 3

Junior Poster

Offline

101 posts
since Jan 2007

Permalink

Mar 19th, 2009

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

php/mysql

architact

Reputation Points: 40

Solved Threads: 7

Junior Poster

Offline

114 posts
since Apr 2008

Permalink

Mar 19th, 2009

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

Are you using link identifier with mysql_query()?

mwasif

Reputation Points: 29

Solved Threads: 47

Posting Whiz

Offline

312 posts
since Dec 2007

Permalink

Mar 19th, 2009

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

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

nav33n

Moderator

Featured Poster

Reputation Points: 524

Solved Threads: 356

Purple hazed!

Offline

3,878 posts
since Nov 2007

Permalink

Jul 24th, 2009

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

Click to Expand / Collapse Quote 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..

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.