Connecting to 2 different tables in 2 different databases.

[ibeblunt]

How do you connect to 2 different tables in 2 different databases, using PHP

For example:

db - vb114
table - users
field - userid

db - sohh
table - albums
field - userid

So they both share the same userid. I know how to do it when everything is in one db, but what about in two db's?


<Edited by ibeblunt on 01-15-2001 at 12:07 AM>

[aspen]

you can't access two DBs in a single query.

If you really need to do this I'd suggest combining the DBs. There is no limit on the amount of tables you can have in one DB and they don't have to be for the same thing.

then again... You can link foreign tables to a DB, but I don't know if that'd work... and its probably not possible in MySQL anyways.

[Ace Nova]

If you absolutely have to you can use two queries and then combine the stuff.

[ibeblunt]

Actually, I just made 2 queries and combined the stuff. Wasn't the hardest thing to do. Might be a little tasking on the server but otherwise, it worked.

[goober]

If you've used ASP, it's a snap. Use one connection object, and run two separate RS.Open statments on it, Only changing the SQL statement. If your server has ASP capabilities I would reccommend this.