[thelist] How do I SELECT for the following...
rabbit_fufu at hotmail.com
Sat Feb 6 06:58:01 CST 2010
I'll do some more research into nested sets, to see if they would be appropriate in my case. It sounds like I am in a situation where I either have to change the datastructure to nested sets, or change the database engine, as the parent->child model seems pretty cumbersome in mysql.
Thanks again everyone,
> Date: Thu, 4 Feb 2010 11:22:35 -0400
> From: sarahwbs at gmail.com
> To: thelist at lists.evolt.org
> Subject: Re: [thelist] How do I SELECT for the following...
> > if you were to switch to the nested set model (characterized by the use
> > of "lft" and "rgt" columns), things will go a lot easier for you,
> > although i can't help you with it as i don't do the nested set model
> Here's a great article that got me started using a nested set model:
> If you want to get more in-depth, try this one:
> sarah adams
> web developer & programmer
> * * Please support the community that supports you. * *
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !
More information about the thelist