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?
Online tutorials for admin panel? 4 db's
Moderator: General Moderators
-
thefreebielife
- Forum Contributor
- Posts: 126
- Joined: Thu Apr 26, 2007 2:59 pm
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
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
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.