Hello , I am working on a project "Online Book Mart" using JSP and Servlets and I am astuck at a position. I am using MySql at back end ,. My query is:- Suppose I clicked a link java books in my project, and there are 100 books info stored in the database but i want to show only 20 at the time and there will be 5 buttons for next page means when i click next, the next 20 books will be displayed from db on the same page.
Hope you got my point , please help me, I am unable to understand how to do this.
hi friend, you can use the mysql limit query as
select * from table_name limit x, y;
where x is the first record and y is the number of records you want to display.
For detail tutorial of mysql limit you can visit the following link Mysql Limit
I hope this may helpful for you.
Hmm, well i was thinking of using limit query, but i would have been great if I had got an illutration, if possible then can you provide an illustration with sample code,