How do you limit the display of only a certain amount of records from a database on one html/jsp page.
I want to retrieve all records relative to my particular search, but I only want to display the most recent 10 items on one page, and make some sort of
1,2,3 counter - each number a link, to other pages which will display the previous 10 records and so on...1,2,3 links relative to how many records in database? I have an auto-increment table so I guess this will determine which are most recent or not, but how would I go about implementing my problem here?
Im working on a jsp app, so that is the reason I have posted this subject here, wasn't sure what forum it would belong.