Apologies for the cross-post, I can't remember if this was a request from NYPHP or the NYCJUG. *blush* Somebody at the last meet was asking about nested sets, and I promised to get them the URL: http://dev.mysql.com/tech-resources/articles/hierarchical-data.html -- Mitch