Re: [PHP] Need a brain to bounce some Mysql/DB thoughts off of!!
On Fri, Dec 12, 2008 at 10:35, Robert Cummings wrote: > > Are you suggesting I'm not tolerant? Pfff. Not since you've let those crosses on the lawn burn out. ;-P And yet, despite all of this, poor ol' php...@lists.php.net is left in the cold. -- http://www.parasane.net/ daniel.br...@parasane.net || danbr...@php.net 50% Off Hosting! http://www.pilotpig.net/specials.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Need a brain to bounce some Mysql/DB thoughts off of!!
On Fri, 2008-12-12 at 11:02 -0500, Daniel Brown wrote: > On Fri, Dec 12, 2008 at 10:35, Robert Cummings wrote: > > > > Are you suggesting I'm not tolerant? Pfff. > > Not since you've let those crosses on the lawn burn out. ;-P Those aren't crosses... they're plus symbols, I was teaching my son basic addition when suddenly a bolt of lightning smacked our car, which then exploded and splashed our symbols with burning gasoline and car wreckage. Yeah, that's what REEALLY happened! > And yet, despite all of this, poor ol' php...@lists.php.net is > left in the cold. There's a php-db list? What for? ;) Cheers, Rob. -- http://www.interjinn.com Application and Templating Framework for PHP -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Need a brain to bounce some Mysql/DB thoughts off of!!
"Robert Cummings" wrote in message news:1229096146.22284.27.ca...@localhost... > On Fri, 2008-12-12 at 06:34 -0600, Jay Blanchard wrote: >> [snip] >> It's Christmas... the season of giving and tolerance :| >> [/snip] >> >> We will return you to your regularly scheduled Robert Cummings Jan 2nd, >> 2009 > > Are you suggesting I'm not tolerant? Pfff. > > :) > > Cheers, > Rob. > -- > http://www.interjinn.com > Application and Templating Framework for PHP > if you break it down he actually said you are very tollerant, but there is an explicit limiter of Jan 2nd on the degree of tollerance supplied by the said Cummings system. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Need a brain to bounce some Mysql/DB thoughts off of!!
I would set it up that a person could elect to work with one or more Departments. If they work on a College, they work on all Departments in that college. Another option is to just let them do one Dept at a time, and that's it. Kind of depends on what people actually DO in this work, most of the time. If the whole-college work is rare, then don't bother with it. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Need a brain to bounce some Mysql/DB thoughts off of!!
On Fri, 2008-12-12 at 06:34 -0600, Jay Blanchard wrote: > [snip] > It's Christmas... the season of giving and tolerance :| > [/snip] > > We will return you to your regularly scheduled Robert Cummings Jan 2nd, > 2009 Are you suggesting I'm not tolerant? Pfff. :) Cheers, Rob. -- http://www.interjinn.com Application and Templating Framework for PHP -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Need a brain to bounce some Mysql/DB thoughts off of!!
At 6:34 AM -0600 12/12/08, Jay Blanchard wrote: [snip] It's Christmas... the season of giving and tolerance :| [/snip] We will return you to your regularly scheduled Robert Cummings Jan 2nd, 2009 In either event, the answers are still good. As for MySQL questions on this list, as I said previously, this list provides more answers than the MySQL list. Again no offense meant to that list -- for there are some very bright people there. However, this list is more responsive; more specific re MySQL queries; and entertains a holistic view of how to design and apply solutions considering more than a single language. This is absolutely the best list for web programming problems. Cheers, tedd -- --- http://sperling.com http://ancientstones.com http://earthstones.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Need a brain to bounce some Mysql/DB thoughts off of!!
[snip] I guess, if people get more responses here, it shows that this mailing list is superior (no offence to the MySQL list :-P ). [/snip] Duh. Was there ever any question? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Need a brain to bounce some Mysql/DB thoughts off of!!
[snip] It's Christmas... the season of giving and tolerance :| [/snip] We will return you to your regularly scheduled Robert Cummings Jan 2nd, 2009 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] 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 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 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 > >
Re: [PHP] Need a brain to bounce some Mysql/DB thoughts off of!!
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 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Need a brain to bounce some Mysql/DB thoughts off of!!
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 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 > >
[PHP] Need a brain to bounce some Mysql/DB thoughts off of!!
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