Jason I got it to work with an inner join but it lists the manufacturers as many times as there are products for the manufacturer. So, if the manufacturer has 10 products in that particular category, the manufacturer is listed 10 times in the filter. Is there a way so that the manufacturer is listed only once? I figure it has something to do with my inner join.
Here's the inner join:
SELECT *
FROM productmanufacturers
INNER JOIN products ON productmanufacturers.ManufacturerID = products.ProductManufacturerID
WHERE ProductCategoryID = Category (I used this as it is the url parameter for the page)
ORDER BY ManufacturerName ASC