Posted by David on 11/11/06 22:03

Hi All,
I'm having problems attempting to access two databases from the same php
script. Both databases are on the same server. Basically, I need to open
db1, then open db2, close db2 and then return to using db1 as the default. I
thought something along the lines of the following would work but it
doesn't:

// connect to DB1
$db1c = mysql_connect (DB1_HOST, DB1_USER, DB1_PASSWORD);
mysql_select_db (DB1_NAME, $db1c)

// use DB1

// now connect to DB2
$db2c = mysql_connect (DB2_HOST, DB2_USER, DB2_PASSWORD);
mysql_select_db (DB2_NAME, $db2c)

// use DB2

// now return to using DB1
mysql_close ($db2c);
mysql_select_db (DB1_NAME, $db1c);

// use DB1

// THE END

However, what I see is that when returning to use DB1, I get access denied
warnings suggesting that the system is using the username and password of
DB2 with DB1.

Also, one thing I have noticed is that the using echo() to render the values
of $db1c and $db2c to the screen gives the same result which seems odd to
me.

Any ideas?.

Ta in advance,
Dave

[Back to original message]