I'm trying to improve my ability to represent hierarchical data.

Mike Hillyer's article
(dev.mysql.com/tech-resources/articles/hierarchical-data.html) on
hierarchical data describes a process of indenting nested set results
based upon their depth within the data tree. The point here is that the
indentation is constructed in MySQL.

I was just wondering if anyone had managed something similar using the
adjacency list model (ALM) and (excuse my ignorance here) a trigger,
stored procedure or a bit of php - but again, building the indentation
in MySQL.

On a related point, Gijs Van Tulder's article
(http://www.sitepoint.com/article/hie...-data-database) purports to
build the indentation in php (using the ALM) but, unless I'm missing
something, the list he builds does not seem to be indented. Am I
missing something?

Anyone get what I'm talking about? Any more info about either the php
or mysql approach greatly appreciated.