Dynamic Navigation

[matthewod]

I have seen this issue addressed before here but here is the situation. I have a product database with a Product Group and Category. I want to be able to list the categories in a product group when that group is selected. For instance:
Group I
-category a
-category b
-cateogry c
Group II
Group III

and so on. Then if Group II was selected only those catgories in that group would be displayed.

So I understand this would be a query within a query to display the categories. Any ideas on how to accomplish this?

Thanks
Matt D

[FMB]

SELECT * FROM groups, categories WHERE groups.id=categories.groupsid order by groups.id

you would have to know the selected group id and in a while loop you can check if that group is selected and display the categories, if not, then only display the group name.