Using multiple databases

[auburn]

I am having problems using multiple databases at the same time.

I am trying to create a discussion board system. I have written a session handler which stores session values in a mysql database. In a separate database I have created tables for the topics, threads, posts, etc for the boards. The trouble is, when I read data from the boards database, the session handler stops working. I believe the problem stems from trying to maintain two connections at once, but how else can I use my session handler while reading/writing data with another database?
I can't combine the databases, because I want the user login to be separate from the boards.

My question is: How can I manipulate more than one database at the same time?

[devinemke]

(assuming mySQL) if the two db's on two separate servers then you must do two separate connections:

$connect1 = mysql_connect('host1', 'user1', 'pass1');
$connect2 = mysql_connect('host2', 'user2', 'pass2');

and then refer to $connect1 and $connect2 accordingly. if they are are on the same server then you need to make multiple calls to mysql_select_db().

FWIW: i would say just put your session table(s) in the same db as the board to simplify things.

[auburn]

Thanks for your advice. I guess using multiple databases is rather pointless for my website. I'll just put everything into one database and that should make things a lot easier.

[sid]

Originally posted by auburn
Thanks for your advice. I guess using multiple databases is rather pointless for my website. I'll just put everything into one database and that should make things a lot easier.

i second that, unless there is no other way