quering 2 db's

Dm_Vinny

Ok here is my dilemma...

I have two databases which I need to access during a search.

The first database "gallery" keeps the users information, name, city, etc.

The second is their submissions in the gallery.

Each submission holds a $keyid which corresponds to there user id held in the "gallery" db.

I need to access both dB's if a user decides to search for a username, now this is quite complicated because if someone decides to search for say "sky" and 4 users have "sky" in their name it has to grab all of those submissions for each user as well.

Any help on this would be appreciated.

drawmack

use the mysql_select_db command to switch between them.

pull data from one
switch
pull data from the other.

Dm_Vinny

I don't think that will work too well... or efficiently im pretty sure one query could handle it just not sure how to do it.

thanks tho

tekky

when you connect to SQL, you select a DB, from then on, that connection uses THAT db for all queries, until a NEW db is selected or its closed.

you can however open 2 connections and select 2 different DB's, one for each... and just alternate between the 2 connection results... I'm fairly sure you cant select from more than 1 database.... thats why mySQL does multiple tables....

consequently, if you are so sure his answer is wrong, and you know it can be done, then do th footwork and search out the answer.... but Im of the same mind as Drawmack there....

drawmack

it's actually a php limitation not a mysql limitation. In perl you could do what the user is proposing. Matter of fact it is the only thing perl has over php. So either find a PERL board and ask for help there or deal with flipping between databases.