Opening multiple connection in MySQL


$handle_db1 = mysql_connect("localhost","myuser","apasswd");
$handle_db2 = mysql_connect("127.0.0.1","myuser","apasswd");
$handle_db3 = mysql_connect("localhost:3306","myuser","apasswd");
$handle_db4 = mysql_connect("localhost","otheruser","apasswd");

mysql_select_db("db1",$handle_db1);
mysql_select_db("db2",$handle_db2);
mysql_select_db("db3",$handle_db3);
mysql_select_db("db4",$handle_db4);

$query = "select * from test"; $which = $handle_db1;
mysql_query($query,$which);

$query = "select * from test"; $which = $handle_db2;
mysql_query($query,$which);

?>
0 Responses