Re: NEXT - PREVIOUS coding
| From: | Manuel Lemos | Date: | Mon, 16 Jul 2001 13:16:03 +0000 |
| Subject: | Re: NEXT - PREVIOUS coding | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-10444@lists.php.net to get a copy of this message | ||
Hello,
Pranot Kokate wrote:
>
> hi.. friends
>
> i have a database (mysql) in which their r many records. Through PHP i want them to display on
> the page.
>
> Main requirement is that there should be a NEXT - PREVIOUS facility. So if there r 20 records
> and suppose only 10 should show up on scren at a time, then a NEXT link should be visible which
> could show the remaining 10 records.
>
> Their can be n no. of records.
Usually you may use the LIMIT clause to specify the range of query
result rows that you want to show.
You may want to try this PHP class that already display query results in
HTML tables eventually spliting the results in pages that you may go
using links like you want.
http://phpclasses.UpperDesign.com/browse.html/package/130
Manuel Lemos