need php display row example script(i.e 1-10, >>next)

[dtotten]

I have 20 of info in my SQL database. I want to display 1-10 first and then when you hit next it shows the rest.

IF you have a example, that would be great

[wempy]

limit from, number_of_rows_returned

[Drakla]

search the forum for 'pagination' and also look in the bookmarked threads sticky around here