How to connect to multiple MySQL servers from PHP
Most of the PHP developers remember only the first three parameters of mysql_connect (host, username, password). There is a fourth parament called $new_link a boolean existscreate a new link. The default value is set to false.
<?php
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
//create a new link/resource
$linkRemote = mysql_connect('remotehost', 'mysql_user', 'mysql_password', true);
//pass the $link/$linkRemote as second argument to
//mysql_select_db,mysql_query functions to work on
//both the servers simultaneously.
//do stuffs
//close both the connections
?>