Re: MySQL Multi-DB Join
| From: | John W. Holmes | Date: | Thu, 18 Mar 2004 15:30:07 +0000 |
| Subject: | Re: MySQL Multi-DB Join | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-33510@lists.php.net to get a copy of this message | ||
From: "Rod Strumbel" <RStrumbel@popp.com>
> If you can select just one db, then what is that
> select_db command really doing?
All it's doing is issuing a "USE database" query so you can say
SELECT * FROM table
instead of
SELECT * FROM database.table
You want to use select_db() so that you don't have prefix all of the tables
in your queries with a database name.
---John Holmes...