Connecting two mysql tables from different databases - PHP answers

This site have interesting examples to connect 2 MySQL tables in different database on different servers
Connecting two mysql tables from different databases - PHP answers

3. //Define your database connections and select your database want to use. In this example I use two connections and two DBs. But you can use more than two.
5. //MySQL Server 1
6. $dbhost1 = "127.0.0.1";
7. $dbuser1 = "dbuser1";
8. $dbpassword1 = "dbpass1";
9. $db1 = "database1";
10. $connection1 = mysql_connect($dbhost1,$dbuser1,$dbpassword1) or die (mysql_error());
11. mysql_select_db($db1,$connection1);
13. //MySQL Server 2
14. $dbhost2 = "xxx.xxx.xxx.xxx";
15. $dbuser2 = "dbuser2";
16. $dbpassword2 = "dbpass2";
17. $db2 = "database2";
18. $connection2 = mysql_connect($dbhost1,$dbuser1,$dbpassword1) or die (mysql_error());
19. mysql_select_db($db2,$connection2);
21. //The SQL statement
22. $sql =" SELECT database1.tablename1.fieldname1 AS field1, database2.tablename2.fieldname2 AS field2 FROM database1.tablename1,database2.tablename2";
24. //Execute query and collect results in $results
25. $results = mysql_query($sql);
27. //Print result until end of records
28. while($rows = mysql_fetch_array($results)){
29. print $rows["field1"]." | ".$rows["field2"]."
    ";
30. }
32. ?>