Knowledge Base: It has unlimited categories and sub-categories.
Database Structure: catid, parentid, ....
**There are two things to do:
** 1) Improve the code of viewing the categories in rows (stop recursive querying)
> "Check this link [login to view URL] 'Nested Set' is a good method, since you would not have to ever do recursive mysql querying (you will have to make a function to parse the data into a hierarchical structure)
> 2) When editing: all categories are viewed on a drop down menu. It needs to have the parent row pre-selected.
> Example:
> Title 1
> Sub-Title a
> Sub-Title b
> Sub-Sub-Title a
> Title 2
> Title 3
> Sub-Title a
>
> If editing 'Sub-Sub-Title a' then preselect 'Sub-Title b'.
> If editing 'Sub-Title b' then preselect 'Title 1'.
> It editing 'Title 1' then preselect top row in drop down menu saying 'Top Level'.
>
> *Look at example code attached.*
>
> **TO DO SUMMARY:
** 1) Stop the recursive querying.
2) Make parent category selected in drop down menu.
THE REST OF THE CODE AND DESIGN HAS BEEN DONE.
**I'm looking to spend around $5 - $10.**