note 31557 added to function.mysql-query

Has anyone been able to crack the problem of connecting across multiple servers while being able to query i.e..... $sql = "SELECT feynman.test.btn "; $sql .= "FROM feynman.test, hephaistos.test "; $sql .= "WHERE feynman.test.btn = hephaistos.test.btn "; mysql_pconnect allows you only to connect to one server at a time, but you can establish 2 connections i.e..... $con1 = mysql_pconnect("hephaistos", "user", "pw"); $con2 = mysql_pconnect("feynman", "user", "pw"); But it does not appear that you can nest or cascade, or otherwise use the two connections within the mysql_query function. Just short of connecting to each table, grabbing data, writing new local tables, and then doing the query has anyone come up with a solution to do these queries "live"? -- http://www.php.net/manual/en/function.mysql-query.php http://master.php.net/manage/user-notes.php?action=edit+31557 http://master.php.net/manage/user-notes.php?action=delete+31557 http://master.php.net/manage/user-notes.php?action=reject+31557