retrieve fields from a database

[I Love Doing Websites]

Hello,

I am working on this page:
products new

This products have a category id in the database. My question is, how do I tell the webpage to retrieve only the products from the category id = "101" and so on. How can I pass that information so the page knows which products to put in the dynamic table?

In the old products.asp page this worked with this string in the url box:
http://www.chloecloset.com/products.asp?cat=98

the fields that my recordset have are:
pDescription, pID, pImage, pSection

I think pSection is equal to cat number

Please advice, I am attaching my code

Thanks

[Newsgroup_User]

I Love Doing Websites wrote:
> Hello,
>
> I am working on this page:
> http://www.chloecloset.com/products_new.asp
>
> This products have a category id in the database. My question is, how do I
> tell the webpage to retrieve only the products from the category id = "101" and
> so on. How can I pass that information so the page knows which products to put
> in the dynamic table?
>
> In the old products.asp page this worked with this string in the url box:
> http://www.chloecloset.com/products.asp?cat=98

You need to filter the recordset with the value from the querystring.

Dooza

--
Posting Guidelines
http://www.adobe.com/support/forums/guidelines.html
How To Ask Smart Questions
http://www.catb.org/esr/faqs/smart-questions.html

[I Love Doing Websites]

thank you dooza!!!!!