This week's book giveaway is in the Jython/Python forum.
We're giving away four copies of Murach's Python Programming and have Michael Urban and Joel Murach on-line!
See this thread for details.
Win a copy of Murach's Python Programming this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Display 20 records per page use MySQL(urgent)  RSS feed

 
Dorj Galaa
Ranch Hand
Posts: 113
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello
My task is display 20 record per page.
where rownum<20 not working on MySQL
 
Kareem Gad
Ranch Hand
Posts: 89
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 89
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Oh i didn't notice it was you Dorj
Keep them comming
------------------
KaReEm
 
Dorj Galaa
Ranch Hand
Posts: 113
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
thanks
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!