I am trying to build a tree for catgories for general websites as part of content managment system for a college project.
ie I have a table in the database called categories with 3 fields.
1. CatID - autonumber
2. CatName - text
3. ParentCatName - number.
I bring them back from the datbase and put them into a string array for the catname and the other two go in to 2-d array.
Problem is I not sure how to build another array that would give me a menu bar.
It looks like I need 4 while statements to get this.
Has anybody attempted or have any ideas?