hiaspire Posted May 27, 2008 Share Posted May 27, 2008 I'm going around in circles trying various query possibilities and wondering if anybody knows... I have some custom section pages that I would like to display the subcategory names along with it printing out any associated specials within those subcategories (random order, limit 3). For example: MAIN CATEGORY NAME SUB-CATEGORY 1 LINK - $1.99 special product link SUB-CATEGORY 2 LINK - $2.99 special product link - $4.99 special product link - $9.99 special product link See more Sub-Category 2 specials I've attempted an additional query to the specials table right after it spits out the sub-category name/id each time within that loop, but not sure if there would be a way to do that more efficiently by altering the initial subcategory query. I'm also running into some trouble getting that to work within the set oscommerce database processes, although I've created queries within queries at times for other projects. We have a lot of specials, so I have used some other code suggestions and contribution modifications to create a dynamic specials page that only shows sales for a particular category (category id fed into it via URL variable), and listing sub-categories is a pretty basic part of the program, but I'm having difficulty doing them both in the same place for multiple sections. Any thoughts? Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.