Managing Hierarchical Data in MySQL

Quite a useful resource for creating multi-level category pickers, etc.

http://dev.mysql.com/tech-resources/articles/hierarchical-data.html