I am currently at a page where I have a recordset of items. Each of these items have a field called SubCategory2 which is the category they fall under.
I am trying to add all the SubCategory2s that are the same so I can display something like Ladder Racks(3), Ladder Racks being the subcategory and 3 being the number of items with that subcategory.
I think i could probably achieve this with a foreach statement my pseudo code would be something like this:
for each SubCategory2 as subcategory
add every subcategory that is exactly the same
then echo subcategory(#ofcategories that were added)
I believe is possible but my PHP skills are not up there yet...can somebody help?