Hi,
I have made a simple forum for our intranet. Can anyone help me as the list of posts is getting quite long and I would like to limit the results to say 10 per page (and have Page 1 2 3 4 > links at the bottom).
Ho do I go about this? Here is how I gain the results from the DB
Thanks in advance
I have made a simple forum for our intranet. Can anyone help me as the list of posts is getting quite long and I would like to limit the results to say 10 per page (and have Page 1 2 3 4 > links at the bottom).
Ho do I go about this? Here is how I gain the results from the DB
Code:
<% while not RS.EOF and not RS.BOF %>
<tr height='25'>
<td bgcolor='#EFEFEF'>&nbsp;<a href="/Forum/Message/index.asp?id=<%=RS("id")%>"><%=RS("title")%></a></td>
<td align="center" bgcolor='#EFEFEF'><%=RS("date_created")%></td>
</tr>
<%RS.movenext
wend %>