#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2001
    Posts
    49
    Rep Power
    14

    scroll through records.


    Hi,

    This one is kinda hard to explain.
    I need to scroll though the records of a database table 5 at a time.

    For example, I have ten records
    1 record1
    2 record2
    3 record3
    4 record4
    5 record5
    6 record6
    7 record7
    8 record8

    I want to display records 1,2,3,4 and 5, then the next time the page is hit, display 2,3,4,5,6, next time 3,4,5,6,7, then 4,5,6,7,8, and then it revolves around to the first one displaying 5,6,7,8,1.

    I have wrote an elaborate PHP script that does this but it takes too long to load it. Is there a sql statement that might do it?

    Vince
    Auction off your web site real estate.

    http://www.webmasterbids.com
  2. #2
  3. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2003
    Location
    Canada - Egypt
    Posts
    60
    Rep Power
    12

    question?


    is this
    "moving from the 1,2,3,4,5 state to the 2,3,4,5,6 state"
    done by a next button
    or
    if I visit the page I see 1,2,3,4,5 and right after me John Smith visits the page sees the 2,3,4,5,6
    ?
    I hope this is of any help to anyone.

    Yassoor
    http://www.WebsitesCreation.ca
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2001
    Posts
    49
    Rep Power
    14
    The latter, if I visit the page I see 1,2,3,4,5 and right after me John Smith visits the page sees the 2,3,4,5,6
    Auction off your web site real estate.

    http://www.webmasterbids.com

IMN logo majestic logo threadwatch logo seochat tools logo