>I'm not sure what you wish to do with this level count, but be careful >if you plan on storing it in the original table. The level count is >already stored inherently in the table through its structure
brad, are you saying that i could do without the level column and rely instead on the query to determine which level each category is on? the reason i wanted this column was so that i could create breadcrumbs with a simple query. also, from the other posts (thanks heaps by the way) is it not necessary to utilise a parent_id column using nested sets? my client wishes to be able to move categories to any other category and also reorder a category within a particular level, so you can imagine i am all twisted about on this at the moment. mike ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231014 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
