I think I made a little progress by using the following ...
SELECT ProductName, ProductCategoryID
FROM products
WHERE ProductCategoryID = colname
... but still curious as to how I get this to dynamically list the products on the page and then link each product to its detail page.