Thread
:
php - Breaking Pages of Data
View Single Post
Reply
Posted 2008-11-04, 08:02 PM in reply to
Goodlookinguy
's post starting
"I know all about the LIMIT clause, but..."
get the count of total results
number of pages=intval((total+perpage-1)/perpage)
check that requested page is >0 and <=number of pages
query the results LIMIT perpage*(pagenum-1),perpage
post results
display pagenav with pages 1 to number of pages
Profile
PM
WWW
Search
WetWired