RE: [PHP-DB] MySQL Multi-DB Join
| From: | Peter Lovatt | Date: | Thu, 18 Mar 2004 15:01:37 +0000 |
| Subject: | RE: [PHP-DB] MySQL Multi-DB Join | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-33504@lists.php.net to get a copy of this message | ||
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@popp.com]
> Sent: 18 March 2004 14:48
> To: 'php-db@lists.php.net'
> 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
>