|
|
Posted by noor.rahman@gmail.com on 07/26/06 14:54
The comments posted on php.net mainly addresses issues where two
SEPARATE queries accessing two different databases. This can be
accomplished with two different DB handles. However, my question is
regarding one handle accessing two databases.... as in, one query
interacting with two different databases.
Possible??
Thanks.
Benjamin Esham wrote:
> 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]
|