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 Quote Link to comment 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 ......"; Quote Link to comment 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! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.