From: "Age Bosma" <[EMAIL PROTECTED]> > I'm trying to work out what the most efficient way will be to get the > complete tree structure from top to bottom of a category tree db.
Search the archives or Google for "nested sets". That's going to be the most efficient database scheme to use. Any parent-child-relationship solution is going to require a lot of queries when your "trees" get large. I second the recommendation for "SQL for Smarties" by Joe Celko, too. Excellent book. ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
