From: "Rod Strumbel" <[EMAIL PROTECTED]>
> 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
27;; '[EMAIL PROTECTED]'
> Subject: RE: [PHP-DB] MySQL Multi-DB Join
>
>
> ?!?
>
> And just use the normal old db selection
> command for it?
>
> Which of the DBs would you select, or does it matter?
>
> mysql_select_db($databasename,$dbhandle);
>
> Think th
Just trying to figure out what that mysql_select_db
is doing.
Oh, and yes... the databases are on the same server
Thanks again,
R
-Original Message-
From: Peter Lovatt [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 18, 2004 9:02
To: Rod Strumbel; [EMAIL PROTECTED]
Subject: RE: [PHP-DB]
assuming the dtaabases are on the same server
$query = "
select db1.table1.field
from db1.table1, db2.table2
where
db1.table1.field1 = db2.table2.field2
"
$result = mysql_query($query,$conection)
HTH
Peter
> -Original Message-
> From: Rod Strumbel [mailto:[EMAIL PROTECTED]
> Sent: 1