Re: recursive queries-tree view implementation
| From: | Roman Ivanov | Date: | Fri, 18 Nov 2005 20:32:24 +0000 |
| Subject: | Re: recursive queries-tree view implementation | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-226078@lists.php.net to get a copy of this message | ||
blackwater dev wrote:
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?
This is complicated. How many people are you planning to have total? How frequently will this info be updated?