basic php / mysql question

Is it possible to connect to two various mysql databases in one page.
If it is, do you have to close connection with the first one before you do so?

if it is possible could somebody please post a sample of code as to how to do it.

thanks in advance

 

You can use different link identifiers. Like:

$connection1 = mysql_connect('...');
mysql_select_db('db', $connection1);

$connection2 = mysql_connect('...');
mysql_select_db('db2', $connection2);

PHP:

Now specify the link in your queries.

mysql_query("SELECT * FROM table", $connection1);

PHP:

 

absolutely awesome.... thanks so much, nice lil green guy for you