Re: [sqlite] Modified Preorder Tree Traversal Algorithm

If anyone is interested on Modified Preorder Tree Traversal Algorithm and has PHP5 on its PC, here is the class with an example file: class: http://www.devpro.it/code/85.html example_file: http://www.devpro.it/examples/TEST_SqliteMPTTA.zip Thank you for debugging. Regards, Andrea Giammarchi

Re: [sqlite] Modified Preorder Tree Traversal Algorithm

John LeSueur wrote: instead of if, use case when then end statement: UPDATE ||table || SETlft=lft + case when lft<".$nodes["n1lft"]." then $inc else -$desc end, rgt=rgt + case when rgt<".$nodes["n1lft"]." then $inc else -$desc end

[sqlite] Modified Preorder Tree Traversal Algorithm

Hi, I am trying to develop a php class that should implement MPTTA on SQLITE and results are great!! BUT, I'm not finding any way to move a branch under another , I' ve just moved successfully a unique branch on same level on another but anymore ... On MYSQL someone use this sintax |SELECT