http://www.weberdev.com/get_example-4005.html that is the url to the PHP 5 object i created, it was created to show the use of the singleton pattern. This means you can only use this class to have one pager per page. i can edit the code if you do not know how to make it so you can have more than one per page.
So you're proposing he uses this class and loads the _entire_ result of a query (with no LIMIT) into an array, then passes that to your class which chops it up into pages and then displays one of them? Do you really think that's more efficient? The question was about how to make two queries more efficient:
SELECT ... FROM table WHERE ... LIMIT x,y SELECT COUNT(*) FROM table WHERE ...
Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/
php|architect: The Magazine for PHP Professionals – www.phparch.com
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php