For what it’s worth, thought I’d post this code in case it helps another newbie. I just wanted to list the child categories (ie, subcategories )of a parent category in a bulleted list. Needed it to remain dynamic since the client will be adding child categories over time. It uses the query module.

The following example will retrieve the child categories of the parent category with an id of 42. Note that the “C” in the linked URL MUST be uppercase (thanks Robin!). This example uses a template named “team” to display the category pages, and I have the my_template_group variable defined at the top of my template file like {assign_variable:my_template_group=“meetingarchive”}. Edit the URL and parent ID to suit your needs.

Thanks for this.

I just made a wiki page with your code, and giving you credit.

I think the alternative is to create a few Category Groups and assign them to a particular weblog.

The Category Group name is like the Parent name then.

stinhambo - 21 May 2007 08:49 AM

I think the alternative is to create a few Category Groups and assign them to a particular weblog.

The Category Group name is like the Parent name then.

Yes, that’s what I ultimately ended up doing, and it worked really well. (See this thread.) It’s nice to have options, depending on what suits your brain and particular purpose!

stinhambo - 21 May 2007 08:49 AM

I think the alternative is to create a few Category Groups and assign them to a particular weblog.

The Category Group name is like the Parent name then.

Can you maybe go into further detail on this? You can view my question here: http://expressionengine.com/forums/viewthread/70743/ and what I’m trying to do.

Thanks,
Deron

Deron, did you see this post? It is the one which suggests uses multiple category_groups (acting as/instead of parents) all assigned to a common weblog, then filtering by category_group id in the templates to single out the “children”. (that is, it circumvents the parent/child category issue entirely.) That’s how PDM finally wound up doing it - not by using his own sql query mentioned in the wiki entry.

At least, that’s how I’m understanding it.

Terry

Terry,

Ah, yes I actually did read it last night, but I guess it was to late and I had be staring at the computer for too long because it flew right over my head. Makes sense now, but now that it does make sense, I think I like your suggested method in the other thread better. I’m thinking that I just don’t want to create another 5-6 category groups. Seems like extra clutter to me…

Thanks

To me, too. And a category parent/child setup makes for something you can add to on the fly from the publish page (the edit categories link is there at the bottom of categories, making it available to clients as well, without having to delve into the Admin CP).

But both methods probably have merits. I’m keeping both in my head for future reference!

Terry

This works great, however I want to get one more thing out of this:

Once on my template (after clicking on the specific subcategory) - I want to have (that specific)Category Name as a header.

I’m trying:

However, that lists all my existing categories (as expected).

Do I have to work on a SQL query for this, or is there an easier path?

See the exp:weblog:entries categories variable pair. It has a category_name output, as well as category_id, and if you use limit=“1”, it will show them for only the current entry on a single-entry page, or for each entry in a multi-entry page if limit is higher than 1.

I hope that helps!

Terry

Thanks, Terry for your help. That works well, however I have to get my categories sorted-out as they’re sort of way deep.

Cheers!

Here’s a much easier solution. I was trying way to hard.

First, I created a new Category Group. So I had no need to do SQL drilling.

I my landing news page; for titles I used:

...which, helps assigning the right breadcrumb once on the news_page. Which (the breadcrumb), looks like this:

...and this will only work, because up on the URL I have C(x) - where x is the category_id...

I mean, I LOVE EE for making my life easy!