Try the following: <?php mysql_connect("firstDB","username","password") or die ("Unable to connect to Server");
mysql_select_db("DB") or die ("Unable to select DB"); ---GET THE INFO YOU WANT AND PLACE IT IN AN APPROPRIATE VARIABLES --FOR LATER COMPARISON mysql_connect("secondDB","username","password") or die ("Unable to connect to Server"); mysql_select_db("DB") or die ("Unable to select DB"); --COMPARE WITH THE VALUES FROM THE VARIABLES ?> I believe that this should work (I haven't tried it though!!!) May the force be with you!!! George ----- Original Message ----- From: "Andy" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, January 04, 2002 3:50 PM Subject: [PHP-DB] How to querry two db in a single statement? > Hi there, > > I would like to make a querry on 2 db. There is info in tables I would like > to compare. > > As I know, there has first to be a conect on the db before the querry. But > how to do this on 2 db?? > > Thanx for any help. > > 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]