Re: 5 results at a time
| From: | R. Kurniawan | Date: | Fri, 08 Sep 2000 04:33:40 +0000 |
| Subject: | Re: 5 results at a time | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-15824@lists.php.net to get a copy of this message | ||
LIMIT 0,5... ;
the first number represents the "start" of selection rows, the second number represents the "number of rows" u want to retrieve...;
therefore u can replace the first number with a variable e.g "$start" and increment 'em by 5...;
to check if there are no more rows can be retrieved, compare "$start" with COUNT(*) query...;