Vanilla 1.1.5 is a product of Lussumo. More Information: Documentation, Community Support.
Help keep Vanilla free:AddChildNode();
function AddChildNode() {
mysql_query('LOCK TABLE tree WRITE;
SELECT @myLeft := lft FROM tree
WHERE CategoryID = 2;
UPDATE tree SET rgt = rgt + 2 WHERE rgt > @myLeft;
UPDATE tree SET lft = lft + 2 WHERE lft > @myLeft;
INSERT INTO tree(Name, lft, rgt) VALUES("FRS", @myLeft + 1, @myLeft + 2);
UNLOCK TABLES;');
}
$result = mysql_query('SELECT Name, lft, rgt FROM tree;');
while ($row = mysql_fetch_array($result)) {
echo $row['Name'].' '.$row['lft'].' '.$row['rgt']."\n";
}CREATE TABLE `tree` (
`CategoryID` int(5) NOT NULL auto_increment,
`Name` varchar(100) NOT NULL default '',
`lft` int(5) NOT NULL,
`rgt` int(5) NOT NULL,
PRIMARY KEY (`CategoryID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
INSERT INTO `tree` VALUES (1, 'Parent1', 1, 2);
INSERT INTO `tree` VALUES (2, 'Parent2', 3, 4);
INSERT INTO `tree` VALUES (3, 'Parent3', 5, 6);
INSERT INTO `tree` VALUES (4, 'Parent4', 7, 8); Error: 1064 Invalid query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ';
SELECT @myLeft:=lft FROM tree WHERE CategoryID=2;
UPDATE tree SET rgt=rgt+2 WH' at line 11 to 3 of 3