RE: [PHP] recursive queries-tree view implementation

> 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 chi

[PHP] recursive queries-tree view implementation

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