i write a code in servlet which retrieve data from the data base like mysql and display the results.at a time it display 15 record.i use link like show next and it display the next 15 records.if i am in a page that display 45-60 records i make a link to backword but it display the intial 15 records.how i make a link that display records from 30-45.means the immediate previous page.what'll be sql query for that.
Author and all-around good cowpoke
posted 12 years ago
Your HTML link must contain enough information to tell the servlet which records to start with. Questions about paging through database retrievals are pretty common here, you can probably find more details by searching the older forum records. Bill