Posted by Benjamin Esham on 07/26/06 07:22
noor.rahman@gmail.com wrote:
> 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?
Take a look at some of the comments at
http://us2.php.net/manual/en/function.mysql-select-db.php
HTH,
--
Benjamin D. Esham
bdesham@gmail.com | AIM: bdesham128 | Jabber: same as e-mail
Más sabe el diablo por viejo que por diablo. (Spanish proverb)
Navigation:
[Reply to this message]
|