php + MySQL question

Codes here !

Moderators: macek, egami, gesf

DoppyNL

Postby DoppyNL » 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


Return to “mySQL & php coding”

Who is online

Users browsing this forum: No registered users and 1 guest