5 results at a time
| From: | Barry Young | Date: | Fri, 08 Sep 2000 03:54:39 +0000 |
| Subject: | 5 results at a time | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-15817@lists.php.net to get a copy of this message | ||
I would like to know how to show 5 results at a time from a query made to a
MySQL database.
I have used the limit command to give me just 5 results, as shown below:
$result = mysql_query ("SELECT * FROM XXX
WHERE make LIKE '$make%'
AND category LIKE '$category%'
LIMIT 0,5 ");
How do you show the next 5 results? and do you need to count the amount of
results, to know when to stop showing the next 5 results.