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: 18
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] MySQL
: 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 that is what has been confusing me.
If you can select just one db, then what
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't have