Hi,

We are displaying a table rows in a webpage - 10 records at a time. Once the user clicks on "Next" the next set of records has to be retrieved.

We are not interested in retrieving all the records and storing it in the application to navigate through the records.

How do I select "selective" records (say from record number 21 to 30) from a MySQL table?

Thanks in advance

Hi,
Why don't you use the limit statement to limit the no of rows returned.

Thanks Nura,

Will try it out and let know.

Thanks Nura,

It works perfectly fine.