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.

Let the new MSN Premium Internet Software make the most of your high-speed 

Query helpAndrew Barnes28 Jan
re: Query helpJeremy March28 Jan