Using more then on DB at once

[php4.23]

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]

[shivabharat]

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:

[Glish]

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;

[php4.23]

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