Multiple Databases

[siafhir]

Is it possible to work with two relational databases at once in MySQL (or any db mgr), including performing joins between a table in one database with a table in another?

The reason I'm doing this is a co-worker and I are each creating our own programs in php, but we don't want the users (employees of our tech support dept) to have to register separately. If someone register's for Mike's program, they can log into mine, and vice versa. If possible we want to keep our db's separate, but one of my other tables needs to join with the 'users' table at some point, and I'm not sure if I can do that with two different db's.

Thanks for your help.

Andrew M.
PHP newbie going guru (hopefully :-)

[Anon]

You can certainly connect to two databases concurrently in the one script a la $conn1=mysql_connect(....); $conn2=mysql_connect(....). Doing joins between databases I suspect would be a lot harder (if it\'s even possible); to answer that would require a guru on the dbms in question.

If the join isn\'t too large, it may be simpler to do it by hand in the PHP script (using the results from one database to do selects on the other).