Multiple MySQL Connections

From: Date: Mon, 13 Mar 2006 16:05:54 +0000
Subject: Multiple MySQL Connections
Groups: php.internals 
Request: Send a blank email to internals+get-22371@lists.php.net 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

« previous php.internals (#22371) next »