SharkBait Posted November 23, 2006 Share Posted November 23, 2006 Does anyone have an example of connecting to two servers and joining two MySQL tables between them?On on server I have information that I need to match up with a database on another server. They have linked tables/fields but I am unsure how I would go about JOINing the two together in PHP.Thanks Link to comment https://forums.phpfreaks.com/topic/28263-joining-tables-from-two-different-servers/ Share on other sites More sharing options...
Barand Posted November 23, 2006 Share Posted November 23, 2006 I don't have the luxury of two servers so you're going to have to experiment with this one, but you can reference columns as "database.table.column" so this is worth a try$conn1 = mysql_connect ('server1', 'user', 'pass');$conn2 = mysql_connect ('server2', 'user', 'pass');mysql_select_db ('db1', $conn1);mysql_select_db ('db2', $conn2);$sql = "SELECT a.col, b.col FROM db1.table1 a INNER JOIN db2.table2 b ON ......"; Link to comment https://forums.phpfreaks.com/topic/28263-joining-tables-from-two-different-servers/#findComment-129275 Share on other sites More sharing options...
SharkBait Posted November 23, 2006 Author Share Posted November 23, 2006 Ah ok, I'll have to try that and see what I get. Thank you! Link to comment https://forums.phpfreaks.com/topic/28263-joining-tables-from-two-different-servers/#findComment-129321 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.