Jump to content


Photo

How can I have a load the next 10 records like some websites


  • Please log in to reply
2 replies to this topic

#1 HGeneAnthony

HGeneAnthony
  • Members
  • PipPipPip
  • Advanced Member
  • 95 posts

Posted 31 May 2006 - 03:57 AM

On a lot of websites I notice the ability to jump forward/back x amount of records and I was wondering how it was done. Is there a way to write a SQL query to return only x amount of records or do I load them all and then sort them out myself in PHP. Any help?

#2 trq

trq
  • Staff Alumni
  • Advanced Member
  • 31,041 posts

Posted 31 May 2006 - 04:00 AM

Search for php record paging tutorials.

#3 iPixel

iPixel
  • Members
  • PipPipPip
  • Advanced Member
  • 496 posts

Posted 31 May 2006 - 06:12 PM

in SQL you can set Limits which will only pull the X amount of records ... and then creating a next page button which will pull the next amount of X records...

But yea... Pagination is the keyword u should search around for.






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users