Chris for some reason I am unable to make this code work on the page. I'm trying to add the ability for a viewer to filter the products in a given category down by the Manufacturer. I don't need a search function only a sort function. I want a drop down of all the manufacturers who carry a product in the given category such as if a viewer is looking at gun cases only the manufacturers who have a gun case drop down. Then the viewer can select one of the manufacturers which changes the products to only the cases carried by that particular manufacturer. The code you have provided may do that but I cannot figure out how to make it work.
In the products table there is a column name ProductManufacturerID. In the productmanufacturers table there is ManufacturerID and ManufacturerName the ID corresponds to the ProductManufacturerID in the products table.
Any more insight would be very much helpful