This might be useful: http://dev.mysql.com/tech-resources/articles/hierarchical-data.html
Cheers, Dave > I built a store application that has a simple product category schema. > Right now, the user can select one or more categories to associate to > a given product. I have a linking table in between those two tables > that resolves the many-to-many. > > Now, I need the ability to let the user create their own categories > and nested categories/subcategories, then associate a product to one > or more of them. Much like a category tree. > > i.e. A shoe needs to be associated to the footwear category, and the > shoes category located within the footwear category. Make sense? :) > > > I've looked at recursion, but I'm on MySQL 5.1, and I don't think it > supports recursive queries. > > Does anyone have any suggestions on the best way to go about this? > Also, what would you implement for the admin tool that creates the > category tree? > > Thanks, > Will ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322708 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
