Re: efficient next/prev page generation
| From: | David Chamberlin | Date: | Fri, 14 Feb 2003 21:03:04 +0000 |
| Subject: | Re: efficient next/prev page generation | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-25644@lists.php.net to get a copy of this message | ||
Just reviewed my post (should do that *before* hitting submit ... sigh ). One minor note, which should be obvious, but just for completeness:
David Chamberlin wrote:
1.SELECT * FROM <table> 2. get the number of rows from result 3. figure out paging scheme 4. SELECT <desired data> FROM <table> LIMIT <startPoint>,<numEntries>I forgot to include the query criteria. i.e., 1. SELECT * FROM <table> WHERE/LIKE <criteria> 2. get the number of rows from result 3. figure out paging scheme 4. SELECT <desired data> FROM <table> WHERE/LIKE <criteria> LIMIT <startPoint>,<numEntries> -Dave