?!? 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:[EMAIL PROTECTED] Sent: Thursday, March 18, 2004 9:02 To: Rod Strumbel; [EMAIL PROTECTED] Subject: RE: [PHP-DB] 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:[EMAIL PROTECTED] > Sent: 18 March 2004 14:48 > To: '[EMAIL PROTECTED]' > Subject: [PHP-DB] 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 >