Re: efficient next/prev page generation

[David Chamberlin <dwc@nautiboy.com>]

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