Re: Need a brain to bounce some Mysql/DB thoughts off of!!

OK, i give u that, Rob. :-) I might just ask MySQL questions here, if i have some. I guess, if people get more responses here, it shows that this mailing list is superior (no offence to the MySQL list :-P ). Tim On Fri, Dec 12, 2008 at 4:04 PM, Robert Cummings <robert@interjinn.com>wrote: > It's Christmas... the season of giving and tolerance :| > > > On Fri, 2008-12-12 at 13:56 +1300, German Geek wrote: > > This list seems to be turning into a MySQL list with a few PHP > questions... > > Tim-Hinnerk Heuer > > > > http://www.ihostnz.com > > > > > > On Fri, Dec 12, 2008 at 1:53 PM, bruce <bedouglas@earthlink.net> wrote: > > > > > Hi guys. > > > > > > Architecting an app that's going to have users interacting with > different > > > levels of the db/tbls, and trying to figure out a few things. > > > > > > The highlevel layout looks like: > > > collegeTBL > > > deptTBL > > > > > > with ->collegeTBL.id = deptTBL.colID > > > > > > I also have a status tbl for each collegeTBL/deptTBL > > > > > > college_statusTBL > > > userID > > > collegeID > > > > > > dept_statusTBL > > > userID > > > deptID > > > > > > with: > > > collegeTBL.id=college_statusTBL.collegeID > > > deptTBL.id=dept_statusTBL.deptID > > > > > > So I limk the statusTBLs to the college/dept TBLs... > > > > > > This is due to the fact that a user can elect to work on either a > college, > > > or a given dept of the college. > > > > > > I'm struggling with a good/best way to figure out how to develop a > query to > > > determine what level of a college, (if any) a user has elected to work > > > with. > > > > > > I can do a multiple join across the collegeTBL/deptTBL, and the > statusTBLs, > > > but this simply gets a large tbl, and I'd have to then parse the > results... > > > I'm trying to figure out if there's a better way, with a single query. > The > > > query would look at the college(status), and then at the dept(status) > to > > > determine what level (if any ) the user has selected. > > > > > > I've got a mysql layout of the various tbls, and inserts if anyone's > > > interested in helping me shake my mind out on this... > > > > > > thanks > > > > > > -bruce > > > > > > > > > > > > > > > -- > > > PHP General Mailing List (http://www.php.net/) > > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > -- > http://www.interjinn.com > Application and Templating Framework for PHP > >