Annoying SQL numbering

[DeepBlerg]

Hi,

I am trying to make NEXT/PREV buttons and all the tutorials I have read are creating errors. I have finally found one that works sort of except, when the sql query returns (as an example) the limit of 10 records, it actually brings back 11 because it starts at 0,1,2,3 etc.

How do you stop it from doing that? Or get around it?

 

[inlandpac]

... limit(0,9) will return 10 rows starting at row 0.

Now that you started with this method of limits, you can just increment by the following method:

... limit (10,19)
... limit (20,29)

and so on.

chad. ICQ: 54380631