Marek Kilimajer wrote:
Indeed! The "flat table model" is simple, efficient and - I think - sufficient. Thanks!This should be of your interest:
http://www.evolt.org/article/Four_ways_to_work_with_hierarchical_data/17/4047/
I also found this article which explains the "fourth" method not really described above, despite the title:
http://www.sitepoint.com/article/hierarchical-data-database/
That method is a bit more complicated but it also allows you to determine the (total) number of child nodes of a node, without an extra SQL query.
/Mattias
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
