Display number of items in subcategory pages, on category page

[binzy]

Hello

Is there a simple way of displaying the number of items in a subcategory in parantheses next to the subcategory link? I currently have many category pages and subcategory pages dynamically created using boolean search queries. I need to display the subcategory links on each category page, so

SubCategory1 (n1)
SubCategory2(n2)
.
.
SubCategoryx(nx)
where n1, n2..nx is the number of items in each subcategory.
I want to do this in a simple manner using PHP without any complicated menu/classes etc..

The number of items in each subcategory is stored as a variable ($numrows) in each subcategory page - I need a way to access the value of this variable on the category page to be able to display it.

Please help!

[johanafm]

binzy;10934892 wrote:

The number of items in each subcategory is stored as a variable ($numrows) in each subcategory page - I need a way to access the value of this variable on the category page to be able to display it.

Not really. It's stored in a variable when that specific page is requested, and only at that time. However, looking at the code that generate the subcategory pages will tell you how that variable is set, which should give you an idea on how to do the same for your subcategory listing.

However, on the subcategory page, there's a big change the number of items is retrieved by a separate sql query, and you do not want to

while("more sub category links") {
	query('number of items for this subcategory');
	"display subcategory link";
}

You'd want to retrieve this information in the same query that retrieves the subcategories.

[Roger_Ramjet]

The solution to this is is to join the subcategory to it's items in a GROUP BY query that counts the items.