Posted by Sjoerd on 06/22/06 08:00

vito schreef:
> Now i'd like to implement a page function to separate 1000 records into 20
> pages.

Add a LIMIT clause to the query.
First page: LIMIT 0, 20
Second page: LIMIT 20, 20
and so on.

http://dev.mysql.com/doc/refman/4.1/en/select.html

[Back to original message]