Re: Hierarchies and MySQL with PHP

Marek Kilimajer wrote:

This should be of your interest: http://www.evolt.org/article/Four_ways_to_work_with_hierarchical_data/17/4047/ Indeed! The "flat table model" is simple, efficient and - I think - sufficient. Thanks!

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