Thread

I’ve tried using {count} and {total_results} but these only show the ID of the category or something like that, not what I expected.

Is there an easy was to get the number of entries found for each category so that I can have something like:

CategoryA (x results)
CategoryB (x results)
etc

Take a look at the excellent plugins over on GWCode.com, more specifically :

http://gwcode.com/add-ons/gwcode-categories/examples/example4

These are really fantastic plugins and allow you to do loads with categories. I personally believe they should be bundled as standard with ExpressionEngine.

Hope that helps a bit.

Best wishes,

Mark

I ended up sorting with with a simple SQL query, I think it was the most efficient way in the end although I do wish I didn’t have to hard code queries.

{exp:query sql="SELECT count(*) as entry_count FROM exp_category_posts WHERE cat_id = '{category_id}' "}
    {entry_count}
{/exp:query

I’ve seen a few add-ons over the years to do that - did you check devot-ee?

I ended up sorting with with a simple SQL query, I think it was the most efficient way in the end although I do wish I didn’t have to hard code queries.

Well if you use the add-on I linked to above then you don’t need to worry any more 😉

I’ve seen a few add-ons over the years to do that - did you check devot-ee?

As above.

I did check out those Add-ons, thanks, but I can’t bring myself to bloat the install with yet another plug-in for a single trivial feature either.