I’m using a category group as a menu. Each category links to a template by using the {path=""} variable. The template then shows the appropriate entries according to category.
My problem occurs with the categories that have “children”. Say one of my menu items is “About Us” and it has two child categories, “About Us 1” and “About Us 2”. When a user clicks on the link, “About Us”, the template displays not only the entries for the category “About Us”, but also “About Us 1” and “About Us 2”.
I would like for the template in question to show entries for strictly the category selected. What I’ve found is that this becomes rather ambiguous because of EE’s practice of assigning “child” categories a category_id twice (one id for parent cat, one id for child).
I’ve been working with some frankly monstrous queries to try to cross check entry_id’s, parent_id’s etc., and can’t help but feel that there must be an easier way to do something as simple as this.
Any wisdom or advice would be much appreciated.