Online tutorials for admin panel? 4 db's

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
thefreebielife
Forum Contributor
Posts: 126
Joined: Thu Apr 26, 2007 2:59 pm

Online tutorials for admin panel? 4 db's

Post 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?
bdlang
Forum Contributor
Posts: 395
Joined: Tue May 16, 2006 8:46 pm
Location: Ventura, CA US

Post 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
User avatar
califdon
Jack of Zircons
Posts: 4484
Joined: Thu Nov 09, 2006 8:30 pm
Location: California, USA

Post 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.
Post Reply