PEAR DB: cannot use more than one database connection
| From: | Ferenc Engard | Date: | Tue, 16 Oct 2001 15:22:27 +0000 |
| Subject: | PEAR DB: cannot use more than one database connection | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-391@lists.php.net to get a copy of this message | ||
Hello,
If I am trying to use more than one connection, then it seems that PEAR
overwrites the first connection's data with the second, at least at the
query time.
I have an object "A" returned by DB::connect(). I can execute queries
with it as long as I don't create another DB object "B" with
DB::connect. At that point the "A" object's queries return with error,
and from the error message it reveals that it tries to execute the query
in the "B" connection's database!
Anyway, if I print out the db_mysql object, it shows the right database
name, yet the error message's native code shows that another database is
tried. :(
What to do?
Thx:
Circum