I read http://www.sitepoint.com/article/hie...-data-database and had a few questions. I tried posting on the SitePoint forums but got nothing.

I have the following structure:

HTML Code:

Code:
- TB
    - cat a
    - cat b
        - sub-cat b
        - sub-cat b
        - sub-cat b
    - cat c
My table structure is 'category_id, name, lft, rgt'.

The category_id is linked in with my items table. And items can be associated with categories or sub-categories.

Any ideas how I can display my products in the following fashion:

HTML Code:

Code:
- TB
    - cat a
        - product from sub category a
    - cat b
        - sub-cat bb
            - product from sub category b
        - sub-cat bbb
            - product from sub category bbb
            - product from sub category bbb
        - sub-cat bbbb
    - cat c
        - product from sub category c
Thanks!