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! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php