Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2004
    Posts
    14

    Question Unanswered: Displaying Selective Rows

    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

  2. #2
    Join Date
    Oct 2005
    Posts
    21

    Slective rows

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

  3. #3
    Join Date
    Oct 2004
    Posts
    14

    Thanks

    Thanks Nura,

    Will try it out and let know.

  4. #4
    Join Date
    Oct 2004
    Posts
    14

    Thumbs up

    Thanks Nura,

    It works perfectly fine.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •