I'm trying to modify a site for a client. It's osCommerce based (MS2.2) and has several additional modules/enhancements and changes from the Vanilla install. The part I'm really stuck on is their search requirements. Basically, they want a search facility in each category that will refine the search (drop-downs are OK) by description, manufacturer, maximum price and minimum price. it is important that this has the option of beginning the search again at any point, and it must ONLY include the products from within it's relevant category with the results being refined upon each choice.
An example of what I need to achieve is here: [url removed, login to view]@@@@1210508398.1186192853@@@@&BV_EngineID=ccdeaddljdfddfjcflgceggdhhmdgmh.0&page=ProductList&category_oid=-27757&show_all=true
but with a field for keywords, a drop-down for manufacturer, a drop-down for both min & max price, a drop-down for subcategories (only where they exist) and a filter to sort by price high or low.