Posted by noor.rahman@gmail.com on 07/26/06 07:02

I was wondering how it may be possible to query 2 MySQL databases using
one query statement from PHP.

For instance: SELECT database1.tableA.field1 UNION
database2.tableB.field2.

My concern is, when connecting to MySQL (or sending a query), I only
specify 1 database connection resource ID. How does that play out when
connecting to 2 databases?

Thanks.

• Next in forum: Re: Query 2 MySQL databases in 1 statement
• Prev in forum: Re: FastCGI and DB connections / global variables?
• Thread view: Query 2 MySQL databases in 1 statement

[Reply to this message]