How to load elements from db when i press next.
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.
Thank you,
View Answers
January 23, 2013 at 10:43 AM
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.
January 23, 2013 at 12:14 PM
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,
Ads
Related Tutorials/Questions & Answers:
How to load elements from db when i press next.
How to
load elements from db when i press next. Hello ,
I am working... 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
Advertisements
same thing i want but from db..
same thing
i want but
from db.. http://www.roseindia.net/tutorial/javascript/dynamicCombo.html
same thing
i want but
from db
how to insert, retrieve data from,to db(code)....
how to insert, retrieve data
from,to
db(code).... Hi.....
i ve... that data will b stored in
db(m using sybase).
2.also hw to retrieve the data
from db.
cn u plz tel me the code in detail.n
i thk it shud b written in jdbc
How to access data yearly from DB in C# ?
How to access data yearly
from DB in C# ?
how to access data yearly
from database in C#.
I have code but
i m not able to retrieve data yearly
from DB table.
string date1 = dateTimePicker1.Value.Date.ToString("dd/MMM/yyyy
how to insert, retrieve data from,to db(code)....
how to insert, retrieve data
from,to
db(code).... Hi,
i have created login page n in that a registration form also in jsp, my doubt is-
when new user... will b stored in
db(m using sybase).
2.also hw to retrieve the data
from db. cn u
how I do select from select in hql
how I do select
from select in hql select RN
from (
select rownum RN, dbid
from ( select *
from profile p where type = 1912 and name like 'a%' order by globalid ) )
where
db_id = 259;
this is the sql
The below hql
nsstring load from file
nsstring
load from file Hi,
How to
load file data into NSString object? Example of nsstring
load from file, basically the html file data into NSSTring object.
Thanks
How can i Dispose Dialog box From LWUIT Component >
How can
i Dispose Dialog box
From LWUIT Component > Hi All,
i... to show a dialog
when i press key "0". again if
i press key "4" the Dialog should... is showing but after
i press key 4, there is know response
import
how to retrieve a checkbox value(retrieve from DB)
how to retrieve a checkbox value(retrieve
from DB)
I facing a problem with checkbox value that already exists inside the database. so
how can
I retrieve those value
from another database table? the table subject and service