wsantos Posted July 26, 2007 Share Posted July 26, 2007 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); Link to comment https://forums.phpfreaks.com/topic/61854-solved-join-within-two-connections/ Share on other sites More sharing options...
Wildbug Posted July 26, 2007 Share Posted July 26, 2007 No, but you can join two databases within the same connection/host. Link to comment https://forums.phpfreaks.com/topic/61854-solved-join-within-two-connections/#findComment-308221 Share on other sites More sharing options...
wsantos Posted July 30, 2007 Author Share Posted July 30, 2007 any suggestions for this? i need to get data from both remote db's.Thanks Link to comment https://forums.phpfreaks.com/topic/61854-solved-join-within-two-connections/#findComment-310996 Share on other sites More sharing options...
Illusion Posted July 30, 2007 Share Posted July 30, 2007 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. Link to comment https://forums.phpfreaks.com/topic/61854-solved-join-within-two-connections/#findComment-311018 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.