?!? 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 is that select_db command really doing? Is it just establishing a mysql session, and once established you can issue pretty much any mysql command through the mysql_query command? If that IS the case, then why bother specifying the DB at all just issue the mysql_connect, and go straight to the mysql_query (although that doesn't work...tried it)? 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:pjln1@xxxxxxxxxxx] Sent: Thursday, March 18, 2004 9:02 To: Rod Strumbel; php-db@xxxxxxxxxxxxx Subject: RE: MySQL Multi-DB Join 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:RStrumbel@xxxxxxxx] > Sent: 18 March 2004 14:48 > To: 'php-db@xxxxxxxxxxxxx' > Subject: MySQL Multi-DB Join > > > Is there a way through the php mysql commands > to join tables between databases? > > Is simple enough at MySQL command line, but can't for the life > of me figure out how to do it in PHP. > > Thanks all, > > R >
