Re: Listing A Certain # Range
| From: | 1LT John W. Holmes | Date: | Mon, 16 Dec 2002 20:41:53 +0000 |
| Subject: | Re: Listing A Certain # Range | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-24187@lists.php.net to get a copy of this message | ||
> LIMIT 5,10
> LIMIT 10,15
>
> Something like that should work.
Not quite. LIMIT n,m where n is the starting point and m is how many rows
you want returned.
LIMIT 5 or LIMIT 0,5
LIMIT 5,5
LIMIT 10,5
etc...
---John Holmes...
> Im using MySQL and PHP 4.2.3 on Apache and Mandrake Linux, I was
> wondering how to get PHP to list let says row 5 - 10 from a database, I
> read the MySQL manual and all I could find is LIMIT 0,5 to list just the
>
> first 5, but I dont know how to make that list 5 - 10 or 10 - 15. Any
> help would be appreciated.