RE: [PHP] MySQL LIMIT 4,6 returns 5 rows!
| From: | Jason Murray | Date: | Wed, 17 Oct 2001 00:32:52 +0000 |
| Subject: | RE: [PHP] MySQL LIMIT 4,6 returns 5 rows! | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-71283@lists.php.net to get a copy of this message | ||
> strange one here, could someone explain why
> select * from subverts where status = 'L' order by
> date_added desc LIMIT
> 4,6
> Reruns 5 rows?
LIMIT 4,6 means "Start and row 4, and give me the next 6 rows"
Jason