Ryan A <mailto:genphp@xxxxxxxxx> on Wednesday, June 21, 2006 10:51 AM said: > @K. Bear - Thanks for the link, I'll check it out as > soon as i get a little time. Read that article. I personally like the "Nested Set" (also called Modified Preorder Tree Traversal) method. It may at first be a little daunting but once you understand how it works, it all makes sense. Only one table is needed and you can have as many children, grand children, etc. as want/need. Chris. p.s. I found out about it originally here at Sitepoint: http://www.sitepoint.com/article/hierarchical-data-database/2 The diagram at Sitepoint is better than the original article (though the original article seems to be more indepth). -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php