Using hyperlink category selection

I would like to use hyperlinks to navigate my product categories instead of the database results. What is the proper syntax to link to the dynamic.asp page showing just a single product category with a hyperlink? Also, can I add additional categories (sub-categories) to the products.mdb table in order to further refine my search abilities?

I'm not getting that to work. I'm using:

http://www.7173parts.com/mall/dynamic.asp?Category=arts
(there are two "arts" products in the Shortcat1 column)

and it loads all of the products just as when I click the search button without a keyword.

That works. Thanks.

Do you have FrontPage? If so:

You would need to edit the template and rerun the FrontPage database region wizard to modify the SQL to incorporate a second "where" clause for the second category. If you don't know how to do that, I would look for a good book on FrontPage and make sure it has at least one good chapter on the Frontpage Database Region Wizard. If you have dreamweaver, then you need a book on Dreamweaver Server Behavoirs.

Yes....the query we create by default with the DRWizard only recognized a single cat...you would need to rerun it to add the second "criteria".