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 ?>