jamesl73 Posted September 9, 2009 Share Posted September 9, 2009 I'm studying a page navigator script in an OOP book I'm reading. They reference the navigator is similar to google's search result navigator at the bottom of the page. At first I thought that somehow the whole list of the results is stored in memory and it's dynamically showing you the pages as you click through them. But now I'm thinking that every page you click on it's re-running the query and selectively showing you the results. Can anyone confirm that that's how a normal page navigator functions? Link to comment https://forums.phpfreaks.com/topic/173695-solved-page-navigator/ Share on other sites More sharing options...
p2grace Posted September 9, 2009 Share Posted September 9, 2009 You are correct in your 2nd assumption. Basically you run one query to get the count(*) of the results, and a second query that only returns the number of results as specified in the current paginated location (LIMIIT = 0,30) etc. Link to comment https://forums.phpfreaks.com/topic/173695-solved-page-navigator/#findComment-915607 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.