You can use the LIMIT operator to do this. It is normal to pass a start parameter between pages (?start=xx) that can be attached to the end of your query along with the number of items you want to list, as follows:
SELECT * FROM table LIMIT $start, $count; When you make your next and previous links simply +/- $count from $start and attach them to the links. Phill On 15/01/07, whoisquilty <[EMAIL PROTECTED]> wrote: > > > > > > > Maybe I'm phrasing the question wrong. > > I want a Next link and a Previous link. Each linking to either the next row > in the sorted > sequence or the previous row. > > How would I do that? > > --- In [email protected], Pete <[EMAIL PROTECTED]> wrote: > > > > In message <[EMAIL PROTECTED]>, whoisquilty > > <[EMAIL PROTECTED]> writes > > >I've got a sorted found set of rows. Is there a command to go to the > next row in > > >the sorted > > >set? > > > > > >I'm trying to create a slide show of photos. They are entered in a table > and > > >sorted by a sortno > > >column. And I'd like to create "Next" and "Previous" buttons. > > > > I think that you are asking the wrong question. > > > > To go to the next row, simply repeat whatever you did to get the > > original row. There are so many different methods, but just repeat what > > you did before. > > > > BUT - that will only work to display all the data on one page, and I > > think that you are going to go to another page, so the sorted rows that > > you got will all be lost. > > > > Are you using MySQL? What is your SELECT command to get the data? > > -- > > Pete Clark > > > > Sunny Andalucia > > http://www.hotcosta.com/comm_1.htm > >
