i was wondering. i have a database where i display 3 types of information.
i have a content management system for add/edit/deleting this info.
i need to create a page that will display this information in 3 sections which have image headers. each will have a group of links. here is code. i am wondering how to sort these repeat regions so that each group only shows the records associated with the Category ID. i have each record assigned to a secondary ID in the database already during insertion but dont know how to display this information.


<img src="press/releases.jpg" width="101" height="8"><br>
<FONT lang=0 FAMILY="SANSSERIF"
PTSIZE="10">
<%
While ((Repeat1__numRows <> 0) AND (NOT Ads.EOF))
%>
<a href="gallery/images/products/<%=(Ads.Fields.Item("Image_Large".Value)%>"><%=(Ads.Fields.Item("title".Value)%></a>
<%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
Ads.MoveNext()
Wend
%>
</FONT> <br>
<br>
<img src="press/clippings.jpg" width="101" height="8"> <br>
<FONT lang=0 FAMILY="SANSSERIF"
PTSIZE="10">
<%
While ((Repeat1__numRows <> 0) AND (NOT Ads.EOF))
%>
<a href="gallery/images/products/<%=(Ads.Fields.Item("Image_Large".Value)%>"><%=(Ads.Fields.Item("title".Value)%></a>
<%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
Ads.MoveNext()
Wend
%>
</FONT>   <br>
</FONT><br>
<FONT lang=0 FAMILY="SANSSERIF"
PTSIZE="10"><img src="press/jackieads.jpg" width="101" height="8"></FONT><br>
<FONT lang=0 FAMILY="SANSSERIF"
PTSIZE="10">
<%
While ((Repeat1__numRows <> 0) AND (NOT Ads.EOF))
%>
<a href="gallery/images/products/<%=(Ads.Fields.Item("Image_Large".Value)%>"><%=(Ads.Fields.Item("title".Value)%></a>
<%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
Ads.MoveNext()
Wend
%>
</FONT>

Post exmaple(s) of your SQL code, sounds like that's where we'd filter and sort.