Re: re: TreeMenu and Recursive algorithms
| From: | Demian Turner | Date: | Thu, 10 Apr 2003 10:59:18 +0000 |
| Subject: | Re: re: TreeMenu and Recursive algorithms | ||
| References: | 1 2 3 4 5 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-4771@lists.php.net to get a copy of this message | ||
Wolfram Kriesing wrote:
can you please send me the sql-dump and the code, with which you've tried it, i will try to get it runningSure, here it is. Thanks, Demian CREATE TABLE tree_nested ( id int(11) NOT NULL default '0', name varchar(255) NOT NULL default '', l int(11) NOT NULL default '0', r int(11) NOT NULL default '0', parent int(11) NOT NULL default '0', comment varchar(255) NOT NULL default '', PRIMARY KEY (id) ) TYPE=MyISAM; # # Dumping data for table
tree_nested
#
INSERT INTO tree_nested VALUES (8, 'Root', -1, 36, 0, '');
INSERT INTO tree_nested VALUES (9, 'PEAR', 4, 27, 8, '');
INSERT INTO tree_nested VALUES (10, 'Tree', 14, 15, 18, '');
INSERT INTO tree_nested VALUES (11, 'HTML', 12, 21, 28, '');
INSERT INTO tree_nested VALUES (12, 'Auth', 5, 6, 9, '');
INSERT INTO tree_nested VALUES (28, 'test3', 11, 22, 19, '');
INSERT INTO tree_nested VALUES (14, 'SimpleTemplate', 1, 2, 13, '');
INSERT INTO tree_nested VALUES (15, 'Auth', -1, 0, 13, '');
INSERT INTO tree_nested VALUES (18, 'Template', 13, 20, 11, '');
INSERT INTO tree_nested VALUES (17, 'DB', 7, 26, 9, '');
INSERT INTO tree_nested VALUES (19, 'Xipe', 10, 23, 17, '');
INSERT INTO tree_nested VALUES (21, 'html', -6, -1, 8, '');
INSERT INTO tree_nested VALUES (29, 'test4', 8, 9, 17, '');
INSERT INTO tree_nested VALUES (23, 'cbvcvbc', 18, 19, 18, '');
INSERT INTO tree_nested VALUES (24, 'Flexy', 16, 17, 18, 'Alan\\\'s template class');
INSERT INTO tree_nested VALUES (26, 'another test1', 24, 25, 17, '');