http://dev.mysql.com/tech-resources/articles/hierarchical-data.html
The link is actually taken from http://book.cakephp.org/view/91/Tree, but it is easy to overlook. This article explains about what the lft and rgt actually mean in terms of the underlying database design - in a nutshell you have lft and rgt in addition to just a parent_id to simplify a lot of queries. On Mar 24, 4:53 am, Aneesh S <[email protected]> wrote: > Yes i got that, but what is the actual relationship of those. What does the > values of lft and rght indicate in connection with positions. > - > *Aneesh S > Software Engineer > *illustris software solutions private limited > TBI, National Institute Of Technology Calicut > Kerala, India - 673601 > Tel No +91 495 3264321 > Fax No +91 495 2287723 > [email protected] <[email protected]> |www.illustris.in > > On Mon, Mar 23, 2009 at 11:29 PM, mscdex <[email protected]> wrote: > > > On Mar 23, 2:52 am, Aneesh S <[email protected]> wrote: > > > thanks for the response, but i'm havng trouble understanding what the > > left > > > and right are.?? I mean, i'm not able to get the relation of those two. > > Pls > > > help me out... > > > The lft and rght fields are used for positioning purposes of the > > record in the tree. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
