PEAR::Pager Tutorials - Paginate database results

Abstract: Paginate database results with PEAR::Pager, in an efficient way. PEAR::Pager was written with the purpose of paginating arrays. While you can fetch all the records from a database, store them into an array and pass it to Pager, this method isn't particularly efficient. If you have large resultsets, it isn't efficient at all. There has to be a better way! In fact, there is... Method #1The