changing db's in included files

[kencl]

Hi Folks,

I'm writing a small script which will be "include()"ed into a large application. The script needs to change databases on an established connection to a MySQL server, which I'll accomplish using mysql_select_db($db). I need to know:

1) Does mysql_select_db() change the selected db for the page which includes it? If it does:

2) How do I determine which db was currently selected before my script was included. I'll need to know this so I can restore the selection.

Appreciate your time.

[devinemke]

if you are going to be querying multiple db's on the same connection then i suggest that you do not use mysql_select_db() at all, just specify the db names in the actual query syntax:

$connect = mysql_connect('host', 'user', 'password');

// get data from db1
$result1 = mysql_query('SELECT * FROM db1.table_name');

// get data from db2
$result2 = mysql_query('SELECT * FROM db2.table_name');

[kencl]

Great advice. That solves the problem by preventing it in the first place. Thanks!