Building Tree from Child level up

[ranta]

I have a database with a category table built using the child/parent relationship, the system users will have access to specific products related to these child categories. Once I have identified the products they have access to I want to build a navigation bar to only inlcude the category the products relate to and its parents (could by multi leveled).

How would you go about doing this????

Any help would be greatly appreciated.

 

[VBrit]

You need recursion to build the parent/child relationships, and a where clause to filter out only the information your current user has access to.

Should be quite simple to do, depending on the format of your data.