Recordset Help

John

If your idea is that after they click on the category the individual pages
list the items in the categories then you can do this with two pages rather
than needed a seperate one for each.

All you need to do one the page that creates the category is add a link to a
page (lets call it CatDetailList.asp) and pass the ID of the category as
part of a quary string. The code would look something like this

<A
href="CatDetailList.asp?CatID=<%=recordset.fields.item("ID").value%>"><%=recordset.fields.item("CatName").value%></a>

Then on CatDetailList.asp you create a recordset that queries the database
and filters based on a URL Parameter call CatID

--
Paul Whitham
Certified Dreamweaver MX2004 Professional
Adobe Community Expert - Dreamweaver

Valleybiz Internet Design
www.valleybiz.net

"pepps" <webforumsuser@macromedia.com> wrote in message
news:epajtl$fj6$1@forums.macromedia.com...
> Hi i asked this question but was unsure of the answer sorry if i am
> unclear
> please help
>
> I have one recordset that displays a table i have created called
> categories,
> these are different music categories ie:
>
> HIp Hop
> Dance
> Reggae
>
> But what i want to be able to do is to create three different results
> pages
> for the categories so if a user clicks on hiphop they go to hiphop.asp and
> son
> on for dance = dance.asp etc.
>
> an this be done by just using one recordset?
>
> I am having alot of trouble trying to find out if this works
>
> Thanks for all your help
>
> John
>