php to get users from multiple user tables

[jersey]

Hello all,

First, allow me to apologize if this is not where this belongs.

I hate to start using a forum by asking for help without being able to provide any in return, but I cant seem to find the answer to my question searching.

I am building a new site that contains a wordpress blog, vanilla forums and mediawiki. All use the same mysql database,but all have their own user table. Thusly, each user needs 3 user names and 3 logins, one for each section. What I would like to do is create a "site-wide" login system, but am unsure where to start, or if it can even be done.

Or, could it be as easy as telling each php login page to check the 3 different user tables?

Or, would I be better off using multiple db's and multiple connects in my script?

If you have any suggestions, or can point me to any references I didn't find, or overlooked, it would be greatly appreciated.

Once again, it seems that I'm in over my head. Well, at least for now anyway.

Thanks,

-j

[bailo81]

When you create a user you will need to create it so that it inserts the same username and password into each database table.

Then the page that processes the login will need to query each table.

Either that or find a way to make all three systems reference one user table