Hi,

I am doing my uni project which has to be completed in the next couple of days. I should have started earlier.......i know !

Basically im making an online shopping site with a database etc....

Anyhow on my homepage there is a a list of categories on the left. These are fed in to the site dynamically via the CategoryName field and each of these categories are made into links which direct to the Products.asp page.

On this page I want to display all the items in a the category which the user clicked. I do not know how to do this and any help would be appreciated. I think it might have something to do with the querystring....or something but im not sure.

If anyone can help I would really appreciate it. If possible advice through MSN at would be much appreciated !

Thanks in advance!

Ferd

First give all the products a ProductID and a CategoryID

Then create the links with a CategoryID URL parameter, something like:

<a href=CategoryPage.asp?CategoryID=1>Fruit</a>
<a href=CategoryPage.asp?CategoryID=2>Vegetables</a>
<a href=CategoryPage.asp?CategoryID=3>Bread</a>

etc....

Then set up a Recordset on CategoryPage.asp (or whatever you call it) something like:

RecordsetName.Source="SELECT Whatever, WhateverElse, AndTheRest
FROM ProductsTable WHERE CategoryID = " & Request.QueryString("CategoryID"

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo