Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:
How would you go about creating a database that has endless groups unlimited levels deep? Ie: Your business has 100 teams and some teams have subteams.. and those subteams can have unlimited sub teams as well.
I have it set up where my database has a subcat field for the parent group in which it exists. I have that part all taken care of.<p. The question then is, when I print out all groups, how do I keep all the groups and subgroups together? For example
and have the result beid gname subgroup 1 red team 0 2 orange team 0 3 black team 0 4 girl team 2 5 guy team 2 6 heavy weights 5
The trick is, I have to be able to advance-sort these teams by many different fields dynamically (id asc, name desc, size desc...) and I'm completely lost on how to go about this.red team orange team > girl team > guy team >> heavyweights black team
This is MySQL if anyone needs to know what database I'm trying to use.
|
---|
Replies are listed 'Best First'. | |
---|---|
Re: Unlimited groups/categories
by friedo (Prior) on Jun 01, 2008 at 01:48 UTC | |
Re: Unlimited groups/categories
by BrowserUk (Patriarch) on Jun 01, 2008 at 02:16 UTC | |
Re: Unlimited groups/categories
by psini (Deacon) on Jun 01, 2008 at 01:50 UTC | |
Re: Unlimited groups/categories
by Anonymous Monk on Jun 01, 2008 at 01:30 UTC |
Back to
Seekers of Perl Wisdom