CodeIgniter Forums

Full Version: Nested sets - update/move nodes with child nodes
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hi all, I'd like some feedback please, if possible.

I'm trying to manage menu items (add new, update and delete items) using nested sets. I have followed these articles
http://mikehillyer.com/articles/managing...-in-mysql/
http://www.sitepoint.com/hierarchical-data-database/
which helped me build the required queries and created the functionality for adding new nodes and delete existing ones.

The problem is that I can't figure out how to do the update functionality, for instance to move a node (either is root node or child node) and all its child nodes/menu items under another node (so the selected node will become a child one) or organize order of the nodes on each level etc.

thanks in advance