Multiple MySQL Connections
| From: | Nick Mitin | 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