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.
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
subject: how i come back to the immediate previous page