Jump to content

Archived

This topic is now archived and is closed to further replies.

php4.23

Using more then on DB at once

Recommended Posts

Can I set up a connection to more then one MySQL database and use them both in a single query?

 

I hope I made sense.

thanks[/b]

Share this post


Link to post
Share on other sites
Can I set up a connection to more then one MySQL database and use them both in a single query?

 

I am editing this post as I accept the answer give by another member. :wink: Good call!

 

But you still have to avoid this.

 

Database name is a just a logical identifer for categorizing. Now how did you have two tables that are linked in two sperate database? I guess you need to spend some time reading RDBMS concepts. :wink:

Share this post


Link to post
Share on other sites

you dont have to make 2 connections, use the syntax below:

 

ie : select tb1.pid,tb2.name from database1.tb1,database2.tb2 where whatyouwant=whatyouneed;

Share this post


Link to post
Share on other sites
Now how did you have two tables that are linked in two sperate database? I guess you need to spend some time reading RDBMS concepts.  

 

Let me explain better. There are two applications both have there own database(local) for storeing their own information, but they access a remote database (on another server) where they share a table with all the registered users.

 

So how can I create a query that can access a local DB and a remote DB at the same time? Can I connect two a local DB and the remote DB and use them both in a query.

thanks

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.