I have a php database search engine that works great, only thing is all results display on one page. I'm trying to figure out a simple handling for breaking it down 20 results to a page without passing the db query results from page to page. Is there a way to formulate a sql query so it gives me the first 20 results, then the next 20 results, etc.? Or is there some other simple method. the only options I'm looking at right now are:
1. re-execute the sql query on each page and only display the results desired (i.e. if you want results 21 - 40 loop through the first 20 but don't display them...
OR
2. Save all results in an array and pass it page to page and display the desired results from that array.
I can't help but think there is a simpler method.
Database Search Engine
Moderator: General Moderators
Re: Database Search Engine
Add LIMIT to the SQL query, it allows to select only number of rows with offset.
Re: Database Search Engine
What you described is called "pagination". There are hundreds of tutorials and discussions on the topic. Just use that search term here in the forum and/or in a search engine.
Re: Database Search Engine
Thank you for your answers. I think the "LIMIT" keyword will do nicely. That handles my problem.
- denewey
- denewey