List:General Discussion« Previous MessageNext Message »
From:Jeremy March Date:January 28 2004 2:57am
Subject:re: Query help
View as plain text  
No.  With the method you're using (storing the parent id with each record) 
you have to use a recursive series of queries to show the subtree levels.  
Take a look at this article--especially the second and third pages about the 
modified preorder tree traversal and nested sets.  There are many other 
articles on this, but I found this one especially helpful starting out.  It 
will let you do what you want, but this method has its drawbacks too.

http://www.sitepoint.com/article/1105

_________________________________________________________________
Let the new MSN Premium Internet Software make the most of your high-speed 
experience. http://join.msn.com/?pgmarket=en-us&page=byoa/prem&ST=1

Thread
Query helpAndrew Barnes28 Jan
re: Query helpJeremy March28 Jan