Disclaimer: I imagine if you are reading this that you know the difference between the adjacency list and nested set methods for storing hierachical data. If not, you should read this first: http://dev.mysql.com/tech-resources/articles/hierarchical-data.html
I’ve been working on a symfony project with a hierarchical category structure, fairly standard sort of a thing. At the start I tried [...]