There's a really good article over on dev.mysql.com by Mike Hillyer that deals with Hierarchical Data in MySQL. This is particularly helpful for category structures, and aggregating categories and counts of items in categories. It's a very comprehensive article, providing sample code for almost any scenario where aggregating data is necessary.
Very nice.
Print | posted on Tuesday, November 08, 2005 3:49 PM