Newb question about SQL

[TTVN]

I'm stuck! 🙂

What piece of codes do I need to display my SQL results in a number list. Example, if my search results: 100 songs total, I want to display 20 songs per page. And If anyone could show me the "prev and next" code.

1. A
2. B
3. C and so on, hope I'm making myself clear 😉

Thank you.
VNTT

[trexx]

you REALLY should use the search-function of this board first. there are countless topics on that subject... try to do a search on "paging" and you'll find what you need.