Re: RV: [PHP] LIMIT() function example
| From: | Foldenyi Tamas | Date: | Thu, 17 Oct 2002 20:11:27 +0000 |
| Subject: | Re: RV: [PHP] LIMIT() function example | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-120395@lists.php.net to get a copy of this message | ||
> 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".