connect to 2MYSQL servers

[Anon]

How can i connect to 2 MYSQL servers from same page? Please help

[[deleted]]

Just do it like the manual says.
Make sure you remember each connection's link-identifier!!

[oeveren]

Kid,

Try this:

$mysqlHandle1 = mysql_pconnect( $HOSTNAME1, $USERNAME1, $PASSWORD1 );

$mysqlHandle2 = mysql_pconnect( $HOSTNAME2, $USERNAME2, $PASSWORD2 );

mysql_select_db("dbase_name",$mysqlHandle1);
$queryStr1="select * from whatever";
$result1=mysql_query($queryStr1);

mysql_select_db("dbase_name",$mysqlHandle2);
$queryStr2="select * from dummy";
$result2=mysql_query($queryStr2);

mysql_close($mysqlHandle1);
mysql_close ($mysqlHandle2);

Hope this makes sense.

Dik

[Anon]

thanks