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
Nick Mitin wrote:
I was trying to create 2 mysql connections.
this is a user question and should therefore not be directed at the
internals list..
-
persistent connections have issues:
http://de2.php.net/manual/en/features.persistent-connections.php -
use the new link parameter to get a new connection for a host you
previously already connected to:
http://de2.php.net/manual/en/function.mysql-connect.php
regards,
Lukas
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.
Yes, this is the same connection.
This is by design.
If you need to open a separate connection - use mysql_connect() with 4th parameter set to TRUE.
--
Wbr,
Antony Dovgal