Re: RV: [PHP] LIMIT() function example
| From: | .: B i g D o g :. | Date: | Thu, 17 Oct 2002 19:34:56 +0000 |
| Subject: | Re: RV: [PHP] LIMIT() function example | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-120389@lists.php.net to get a copy of this message | ||
I have no examples per say, however, you can review LIMIT on mysql's
website.
and example query would be like:
select article_id, article_title from articles limit 0, 10;
This would give you results from 0 - 10.
So you can then do a query on page 2 like:
select article_id, article_title from articles limit 11, 20;
On Thu, 2002-10-17 at 13:30, Francisco Vaucher wrote:
>
> Can anybody help me with this pls...
>
>
> ----- Original Message -----
> De: Francisco Vaucher [mailto:fvaucher@tycoint.com]
> Enviado el: jueves, 17 de octubre de 2002 15:05
> Para: PHP List (E-mail)
> Asunto: [PHP] LIMIT() function example
>
>
> Hi to all,
>
> Can anybody give me an example on how to use the limit() function of MySQL
> to build a paging script with PHP ?
>
> If anybody have an example It would be great!
>
> Thanks a lot!
>
> Francisco
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
--
.: B i g D o g :.