X-Cart forums

[pdheady]

I need to display how many subcategories belong to a category id. { $subcat.subcategory_count } should work and it's not.



{if $cat eq "655"}
<div class="bodytext1">There are <span style="color: #128B94; font-weight: bold">
{ $subcat.subcategory_count }
</span> styles to choose from.</div>
<br>
{/if}

[pdheady]

For example I click on category A and I get 4 categories as below.

Category A
subcat 1
subcat 2
subcat 3
subcat 4

Now i just want the total subcat 1-4. So the subcat total = 4.

I need that value displayed on my page somehow and i've looked everywhere for it. The { $subcat.subcategory_count } will only total what's below the subcategories (ie. subcat1 = 0, subcat2 =0, etc). I want the total count of the subcat results.

[pdheady]

I found this code in /include/categories.php

I wonder if I can do something with this?

#
# Count the subcategories
#
$category["subcategory_count"] = func_query_first_cell("SELECT subcategory_count FROM $sql_tbl[categories_subcount] WHERE categoryid='$cat'".($current_area == 'C'?" AND membership = '".addslashes($user_account["membership"])."'":""));

return $category;
}