The Pear Pager class works like a champeen, too. It'll paginate results however you'd like it to.

~Rob


Chris W. Parker wrote:
Robert Cummings <mailto:[EMAIL PROTECTED]>
    on Thursday, August 21, 2003 4:46 PM said:


Don't retrieve ALL the queries then
only display a subset. Otherwise what's the point of using the LIMIT
clause for conservation of resources?  The "SELECT COUNT( * ) FROM
foo" query is usually optimized to be extremely fast so the first
query is almost negligible in contrast to the second.


Heh... I've never really used COUNT() so I'll have to see how much it
speeds up my searching. :)


Good idea!


Chris.


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



Reply via email to