Additional Page with All Products in Alphabetical List

Hello,

I would like to display some of our products in their respective sub-categories (already done, no problem), but also on a single page... just the product title (hyperlinked to the product), listed in alphabetical order.

From a php/mysql standpoint, I have done this a million times in other custom applications. What I don't know is how to accomplish this in Zen-Cart. (I suppose a side question would be: can I have, say, a category page call some php/mysql code that would read the Zen-Cart database?)

I'm running v. 1.3.0.1

Thanks for any help or direction!

not sure about v 1 3 0 but its already there in v138a "all products" in catagory menu, time to upgrade? :)

That feature is in 1.3.0.1 as well, however, the functionality I'm looking for is (a) limited to a single category (and its subcategories), and (b) appears in the store alongside other subcategories on its main category page.

Like this:

Main Store Page

- Category 1

• Category 2
  

  - (Subcategory) View Products by Category (contains subcategories)

• (Subcategory) View Products by Title