[PHP-DB] Re: efficient next/prev page generation

[David Chamberlin]

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


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php