[SOLVED] Join within two connections

[wsantos]

Is it possible to make a join from two connections?

 

  $con1 = mysql_connect("ip1","user","pwd");
  if(!$con1)
  {
    die('Could not connect: ' . mysql_error());
  }
  $db1 = mysql_select_db("table1",$con1);

  $con2 = mysql_connect("ip2","user","pwd");
  if(!$con1)
  {
    die('Could not connect: ' . mysql_error());
  }
  $db2 = mysql_select_db("table2",$con2);

[Wildbug]

No, but you can join two databases within the same connection/host.

[wsantos]

any suggestions for this? i need to get data from both remote db's.Thanks

[Illusion]

We need to close first connection in order to connect to the second one, If at all u don't need both databases at a time , u write two functions(including mysql_close(); ) two deal with the two connections depending upon the need, u can call one.