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 > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
