Well that thread title is a mouthful I've been using this article as a reference for setting up a categories hierarchy in MySQL. Maybe I'm not as bright as other but I've been having a bit of trouble getting my head around it. So far I can add categories no worries, that part works great but that's as far as the article goes

I've had a play and I can figure out how to delete a base node but how do I go about deleting a higher up category and taking all of it's subcategories with it? And what about moving categories and subcats around while keeping structure? I would rather this method as once I learn how to use it properly it seems to be much more powerful than the other method mentioned in the article I ust can't seem to get my head around it.

Does anyone have any answers to my questions or maybe some resources that'll help me find the answers on my own?

Thanks