Re: How to querry two db in a single statement?

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" <news.letters@gmx.de> To: <php-db@lists.php.net> 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: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >