Re: RV: [PHP] LIMIT() function example
| From: | Foldenyi Tamas | Date: | Thu, 17 Oct 2002 20:16:15 +0000 |
| Subject: | Re: RV: [PHP] LIMIT() function example | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-120396@lists.php.net to get a copy of this message | ||
Sorry. It's wrong too. The correct is "LIMIT 10,10".
> > 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;
>
> limit 11, 20 is wrong! You miss one record. You should use "limit 10, 20".