formatting search results with SQL databases

I am working on a search engine page. Right now, when you run a search it displays all of the results. I want to have it so it only shows 10 results at time with a "next" button that will lead to the next 10 results and so on.

This is what my code looks like:

_____________________________________________________________________
<div ID="FAQRESULTS" STYLE="BACKGROUND-COLOR:WHITE;WIDTH=750;height=600;overflow:auto">

<% counter=1
pageCounter=1

IF NOT RECORDSET.BOF OR NOT RECORDSET.EOF THEN
RECORDSET.MoveFirst
DO WHILE NOT RECORDSET.EOF

%><BR>

<%=counter%>.

<a href="moreInfo.asp?project_number=<%=trim(recordset("PROJECT_NUMBER"))%>">
<%=trim(recordset("DESC_OF_PROBLEM"))%></a><br>

<% counter=counter + 1
IF NOT RECORDSET.EOF THEN RECORDSET.MoveNext
LOOP
END IF%>




</div>
<a href="searchResultsIS.asp?counter=<%=counter%>">Next</a>

_____________________________________________________________________


Does anyone know how I can do this?? Or if someone knows of a different way to go to about it or a good example of a search engine I could use. Your help will be greatly appreciated!!!!