Displaying query results over multiple p

[Anon]

I am fairly new to db programming, and was wondering, how do I get results to display over multiple pages. I mean here's my problem,
I have a catagory with 50 entries, I want to display all the entries but only want 10 entries per page. How do i go about doing something like this? It seems like it would be a very common thing, I just cannot find information on it (it would help if I knew where to start). Any help would be great thanks

[Anon]

Use the LIMIT syntax. SELECT FROM table WHERE condition LIMIT 0,10
would return the first ten rows. Then SELECT FROM table WHERE condition LIMIT 11,21 will give you the next ten and so on.

[cheald]

I typically do something like this:

I do a "lite" version of my select to get the number of rows I'm going to have, total. I then pass this number, the current page, and the results per page to a custom function which prints out a page list. I then repeat the full query, adding in the LIMIT syntax to get only a specific set of rows, which I then display.

Hope that helps...