Posted by blackwater dev on 11/18/05 20:17

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!

• Next in forum: Re: [PHP] testing on a local server
• Prev in forum: Re: [PHP] add more features on working php?
• Thread view: recursive queries-tree view implementation

[Reply to this message]