This tutorial explains how to paginate database results using PEAR::Pager and Pager_Wrapper. The latter is useful, because without it (Pager_Wrapper), you are selecting the ENTIRE result set for each page, which undoes one of the important advantages of paginating.