You are here: Re: Query 2 MySQL databases in 1 statement « PHP Programming Language « IT news, forums, messages
Re: Query 2 MySQL databases in 1 statement

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]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация