Send a blank email to [email protected] to get a copy of this message
I was trying to create 2 mysql connections.
$l1 = mysql_pconnect(“localhost”, “user”, “pass”);
mysql_select_db(“db1”, $l1);
$l2 = mysql_pconnect(“localhost”, “user”, “pass”);
mysql_select_db(“db1”, $l2);
The $l1 and $l2 now contains different resource ids (#1, #2), but
mysql_query(“select * from table”, $l1) somehow uses the second connection.
If I change the username in second connection to user1 (assuming user1 as valid login)
$l2 = mysql_pconnect(“localhost”, “user1”, “pass”);
mysql_select_db(“db1”, $l2);
everything is fine.
I found this pretty strange.
________________________________________
Nick Mitin
Borzov-Mitin Solutions, The // http://tbms.ru