select * from product where category = '#category#' and special_offer = yes order by prod_name
You are in Category:
#ucase(category)#
Sorry No Special Offer is available
for this category.
In order to view product specification click on the desired product name below.
Product Name
#prod_name#
Back
