It depends, how are you creating the connections, and where are you keeping
the connection ID
and when you query, or select database, or anything to do with the
databases, do you make sure you specify that connection id?
//Notice the TRUE, that creates a new conenction, and doesnt use the
existing connection (hence returning a different id)
$sqlconnection1 = mysql_connect('test.com', 'username', 'password');
$sqlconnection2 = mysql_connect('test.com', 'username', 'password', TRUE);
then when you select databases and query youll have to specify that
connection!
//choose DB 1 on connection 1
mysql_select_db('mydata1', $sqlconnection1);
//choose db2 on connetion 2
mysql_select_db('mydata1', $sqlconnection2);
//and querying
//this will select the table named table from the mydata1 database
mysql_query("SELECT * FROM table WHERE name='me'", $sqlconnection1);
//this will select the table named table from the mydata2 database
mysql_query("SELECT * FROM table WHERE name='me'", $sqlconnection2);
hope thats what you were after
--
Luke
_________________________________________________________
"Donald Tyler" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
OK, now I have done some work and it gets even stranger.
Two Objects
Validator
Importer
Both objects have private variables called $this->Connection
However, when I change the DB for one objects connection pointer, the other
objects connection pointer ALSO changes DB.
Is it not possible to have two completely separate DB connections active at
the same time?
-----Original Message-----
From: Donald Tyler [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 22, 2004 3:08 PM
To: [EMAIL PROTECTED]
Subject: [PHP] 2 x DB connections at once
I thought this was possible, but it doesn't seem to be working:
I have a class, that has a private variable called $this->Connection, which
is a Database Connection pointer to a MySQL database. During the lifetime of
the Class, it uses the connection multiple times without a problem.
The class also uses a function from an include file that has its OWN
Database Connection pointer. And it seems that for some reason, as soon as
that external function is called, the Private Database Pointer within my
Class suddenly points to the Database name that the external functions
Database Pointer was using.
I ALWAYS specify which connection pointer I want to use when selecting the
DB and doing a mysql_query, so I have no earthly idea how the external
Connection pointer is affecting my Private Connection Pointer.
I hope I explained that well enough; it's real difficult to put into words.
Does anyone have any idea what might be happening?
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
