php + MySQL question

[DoppyNL]

in a mysql query you can use "LIMIT 0,5"at the end of the query to limit the number of results.

LIMIT 0,5 means: return 5 records starting from position 0

make a next-button in wich you transfer the current limit variables to the same page and change you're query that way. So by clicking next a couple of times you're query may look like "select * from table LIMIT 15, 5;"

Greetz Daan