I tried it on my web server and it didnt work
I used:
$conn1 = mysql_connect("1.1.1.1", "user", "pass");
$conn2 = mysql_connect("2.2.2.2", "user", "pass");
$query = "SELECT * FROM table1";
$results_from_conn1 = mysql_query($query, $conn1);
$results_from_conn2 = mysql_query($query, $conn2);
and replaced:
$dbinfo = array(); $dbinfo[host] = "localhost"; $dbinfo[user] = "****"; $dbinfo[pass] = "****"; $dbinfo[db] = "****"; if ($dbinfo) { $connection = @mysql_connect ($dbinfo[host], $dbinfo[user], $dbinfo[pass]); if ($connection) { @mysql_select_db ($dbinfo[db]); } else { echo "Unable to connect to database"; exit; } } else { echo "You need to setup your mysql information";
in http://php.privatepaste.com/f0IKClQgM6
What did I do wrong?