Perhaps something like:
$query = "SELECT db1.table1.*,db2,table1.* FROM db1.table1,db2.table1 WHERE
db1.table1.field=db2.table1.field";
$result = mysql($query) or die("Error:".mysql_error());
Advertising
-----Original Message-----
From: Andy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 02, 2002 9:22 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Making a Querry on two db possible?
Hi there,
I have two tables in two different db. Now I have to compare those records.
How can I do this from PHP? As I know I have to connect to the db first,
than make the querry. How can I compare them? Is there another way, than
first writing the data into an array and then comparing?
Cheers Andy
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
