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