recursive queries-tree view implementation
| From: | blackwater dev | Date: | Fri, 18 Nov 2005 18:17:46 +0000 |
| Subject: | recursive queries-tree view implementation | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-226070@lists.php.net to get a copy of this message | ||
I am sure others have encountered this so I am just looking for ideas.
Say I have an ancestry application where the users can enter parents,
children, etc. The children have children, etc.
table people
id
parent_id
what is the best way to pull this from the db minimizing the number of
queries to build a tree view of parents to children?
Thanks!