include page number in a table

[greedyisg00d]

Hi I have a hard coded table in my page which the values are retrieve from a database. The rows and cells are produced using while loop. My problems is sometimes the query result is more than 100 rows and what I want is the result that will be viewed will only contain 20 rows and users can navigate the other rows though page number. Any sample codes will be appreciated. Thanks

[__berfuzz]

Search for paging system and you probably find a bunch.

[Weedpacket]

Or "pagination" (there's a couple listed in this forum's FAQ).