Limit & hyperlinking

Hello al, Another question, if retrieving records from a database, I can use LIMIT tolimit the records, however does someone have some examples on sites or otherwise that would show clearly how I could limit the records per page and dynamically produce a hyperling in the HTML result that would allow retrieval of the next (limit amount) of records ? I am also interested in functions to sort by date, record ID etc. Again, thanks for any pointers. Greg