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
>
1
Reply
AdChoices