Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003

    Unanswered: Displaying records in a cyclic process

    Hello everybody,

    I have 100 records in a table and I would like to show 1 to 40 today and 41 to 80 tomorrow and 81 to 20 the next, something like in cyclic process.

    How should i write my sql query??

    Many thanks

  2. #2
    Join Date
    May 2002
    Vancouver Canada
    You could precisely specify the limit clause to return the range of rows you want, controlled by what ever programming language your system is using.

    Or, I don't know if functions are permitted with LIMIT, but if so, using a MySQL date function, with a calculation, might be a better way to go.

Posting Permissions

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