Page 1 of 1

Online tutorials for admin panel? 4 db's

Posted: Thu Jun 07, 2007 5:36 pm
by thefreebielife
i was going to hire someone to do this, but i would like to try myself.

i understand php well, but am confused how to get info from 4 separate databases.

does anyone have any help/tutorial that they could guide me towards?

Posted: Thu Jun 07, 2007 6:51 pm
by bdlang
You're asking about how to perform a JOIN?

SQLzoo.net : JOIN operation

MySQL Manual : Tutorial : using foreign keys
(don't just read that last section, read the entire tutorial)

MySQL Manual : SQL statement syntax : JOIN syntax

Posted: Fri Jun 08, 2007 1:33 am
by califdon
I read his question as how to connect to multiple databases. If that's the question, you can simply execute multiple connections sequentially, execute queries, and go on to the next connection. If you need to use data from more than one database in the same query, though, that's another issue and I don't know if that can be done. Of course, if the data volume isn't prohibitive, you could query one at a time and store the result set in an array. But maybe I'm missing the point. Wouldn't be the first time.