Next, Previous Help

[jray214]

Does anyone have some code that can do the following.

Total Records 100

I want to do a query that list only 25 records at a time and have a button at the bottom that when clicked will list the next 25 or go back 25 records.

Sample:

1
.
.
.
.
25

[Next 25] [Prev 25]

Or

[1-25] 26-50] [51-75] [76-100]

Thank you

Jim

[mahers]

http://www.phpfreaks.com/tutorials/43/0.php
http://www.spoono.com/tutorials/php/nextprev/

[devinemke]

use the sql LIMIT clause

mysql_query ('SELECT * FROM tablename LIMIT 0, 25')