Karim
|
| Posted: 03/26/2002, 10:34 AM |
|
How can I build a tree with multiple levels using the Tree function modifing the Custom Show event?
Sample date
ID ParentID Title<br>
13 -1 Top<br>
18 11 Main <br>
21 18 Sub Main 1<br>
22 18 Sub Main 2<br>
23 18 Sub Main 1<br>
24 18 Sub Main 1<br>
27 18 Sub Main 1<br>
34 31 Test<br>
36 35 Test 2<br>
43 32 Test 3<br>
86 30 Test 4<br>
87 86 Sub test 4<br>
88 86 Sub test 5<br>
89 86 Sub test 6<br>
90 86 Sub test 7<br>
91 86 Sub test 8<br>
92 86 Sub test 9<br>
93 86 Sub test 10<br>
94 86 Sub test 11<br>
96 34 Sub Test<br>
97 34 Sub Test 2<br>
99 43 Test 5<br>
<br>
Thanks
|
|
|
 |
Nicole
|
| Posted: 03/27/2002, 12:51 AM |
|
Karim,
fist of all slq select statement should return as many fields as you want to be displayed on the screen. So modify sql query.
Then find the line where tree categories are output to the page and include custom selected fields to it. E.g. for PHP+Tempaltes the original line is:
$tpl->set_var("CategoryID", tohtml($db->f("category_id")));
modify it to include additional fields:
$tpl->set_var("CategoryID", tohtml($db->f("category_id"). "" . $db->f("parent_category_id")." ". $db->f("category_id")));
|
|
|
|
Karim
|
| Posted: 06/14/2002, 8:55 AM |
|
Thanks Nicole, I need to figure out how to use it with ASP. 
|
|
|
|
|
