Re: Pager_Sliding DB/Templates example
| From: | Lorenzo Alberton | Date: | Wed, 23 Jul 2003 07:39:08 +0000 |
| Subject: | Re: Pager_Sliding DB/Templates example | ||
| References: | 1 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-6753@lists.php.net to get a copy of this message | ||
On Wed, 23 Jul 2003 16:49:28 +0930, Joseph Blythe wrote:
> Hi everyone,
>
> Has anyone got any examples of using Pager_sliding with DB and
> templates, I have used DB_Pager but cant seem to get Pager_Sliding
> to function properly ?
>
> Any help/examples appreciated,
> Regards,
> Joseph
Hi,
there are some examples in the package docs and in the manual:
http://pear.php.net/manual/en/package.html.pager-sliding.php
Maybe you can't make it work properly because you LIMIT the
DB resultset before passing it to the Pager.
Pager & Pager_Sliding can't deal with DB resultsets,
they work with arrays. They take the whole array, and break
it in smaller chunks. If you want to LIMIT the resultset
directly within the Pager, you have to use DB_Pager.
However, a quick look @ the examples in the manual
should make it clear.
Best regards,
Lorenzo