Hieratic Category Query

[eluser]lightnb[/eluser]
I'm not sure how to make either method work... So the best option is whichever I can get working first.

I have "read" working fine on the left-right one. I just can't get the insert function to work.

The article says to do this (in "normal" mysql):

Code:

LOCK TABLE nested_category WRITE;
SELECT @myRight := rgt FROM nested_category
WHERE name = 'TELEVISIONS';
UPDATE nested_category SET rgt = rgt + 2 WHERE rgt > @myRight;
UPDATE nested_category SET lft = lft + 2 WHERE lft > @myRight;
INSERT INTO nested_category(name, lft, rgt) VALUES('GAME CONSOLES', @myRight + 1, @myRight + 2);
UNLOCK TABLES;

But it's not translating well into $this->DBish.