I'm looking at catalog/category/view.phtml
So I suppose I should use getChildren, then loop through the children. How will I get from each child category a single product based on a certain sort order for the collection?
I need to limit the db query with a "LIMIT 1" clause or something like that, so that I do not load a bunch of products into PHP.
Suppose my categories are as such:
root_catalog |-T-shirts |-Long Sleeve |-Short Sleeve |-Cell Phones |-Smart Phones |-Dumb Phones
I would like to show one image for each subcategory. I would like to do this by dynamically getting the list of subcategories and getting the image for the 1st product in each subcategory. When you click on that image, you are taken to the subcategory (and, conveniently, you also see the actual product that was used as an example in the navigation image).
I know I may be going about this the wrong way. If so, please advise.