displaying database items

I am connecting to a database that generates multiples results, which is fine as that is what I want it to do, but I only want to display 5 results per page and at the top and bottom have the option for the user to use a drop down menu to increase the number of page results OR if they don't want the number of results to change, give them the option to move to the next page and back...<br><br>The code for the database connection works fine... just need a hand polishing it to give the user those options...

In Select statement use "SELECT TOP 5 * FROM dbname" for the first screen to keep processing low.<br><br>For subsequent searches return all records but loop based on a querystring so the links FORWARD and BACK could be a href='page.asp?recordsstarting=25'Next Page<br><br>The script would loop until record request.querystring("recordsstarting"), then display the next 5, then exit giving an easy way to only display 5.<br><br>The only problem with this is the server has to read all records everytime the page is requested. Should be alright for small sites