Re: displaying n number of rows at a time
| From: | Chris Lee | Date: | Tue, 05 Dec 2000 22:11:41 +0000 |
| Subject: | Re: displaying n number of rows at a time | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-28756@lists.php.net to get a copy of this message | ||
use LIMIT
SELECT * FROM product LIMIT 0,10;
that will select the first 10
SELECT * FROM product LIMIT 10,10;
this will select the next ten
SELECT * FROM product LIMIT 20,10;
see :)
Chris Lee
Mediawaveonline.com
In article <90jjrq$ksl$1@toye.p.sourceforge.net>, "Rock Kake"
<__zzz@907305jb2.com> wrote:
> What is the best way to display n number of rows at a time selected from
> a MySQL database,
>
> eg. a product catalogue would need only about 5 records at a time
> displayed on one screen
>
> with display previous 5 and next 5 items?
>
>
> Rock Kake
>
>
>
>