PEAR::DB - two simultaneous connections
| From: | Maciek Szczytowski | Date: | Thu, 26 Jun 2003 14:26:27 +0000 |
| Subject: | PEAR::DB - two simultaneous connections | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-6258@lists.php.net to get a copy of this message | ||
Hi.
Is it possible to be connected to 2 databases at the same time?
I have something like that:
$DB1 = DB::connect($dsn1,false); //database1
$DB2 = DB::connect($dsn2,false); //database2
$result1 = $DB1->query($sql1);
$result2 = $DB2->query($sql2);
Now, $result1 is a PEAR_Error:
db_error Object
(
[error_message_prefix] =>
[mode] => 1
[level] => 1024
[code] => -18
[message] => DB Error: no such table
[userinfo] => select sth_id from sth_table [nativecode=Table
'database2.sth_table' doesn't exist]
[callback] =>
)
So, $DB1 is connected to database2. Why?
I use MySQL.
Regards,
Maciek