php + MySQL question

Codes here !

Moderators: egami, macek, gesf

Post Reply

Wed Sep 18, 2002 2:24 am

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

Post Reply