Display 20 records per page use MySQL(urgent)

[Dorj Galaa]

Hello
My task is display 20 record per page.
where rownum<20 not working on MySQL

[Kareem Gad]

mySQL uses this syntax
select * from table limit 0,20
the 0 denots the starting row
20 denotes the number of rows you want to retrieve starting from starting row
so retrieving the next 20 would be limit 20,20
then limit 40,20
and so on.
this question should belong i guess in another forum not on the jsp and servlet page i think what do u think moderator ? move it?

------------------
KaReEm

[Kareem Gad]

Oh i didn't notice it was you Dorj
Keep them comming
------------------
KaReEm

[Dorj Galaa]

thanks