Don't know the official name, dispersing comments upon multiple pages

Discussion in 'Scripts, 3rd Party Apps, and Programming' started by andylpsx, Dec 6, 2013.

  1. andylpsx

    andylpsx New Member

    Messages:
    29
    Likes Received:
    1
    Trophy Points:
    3
    So I have a guest book page which allows users to add comments to my page. I want to display the 50 newest comments which would be With ID's ordered by DESC. I got that much done but if I have 51 comments I want that one oldest one to be on a new page with a little number or arrow at the bottom of the page to access it. It's used by almost every forum, youtube, Facebook and more. I just don't know the exact process of making a system. I am not asking someone to write the code for me but could you send me a link to a tutorial of how it is done.

    I assume it uses the LIMIT 50 in the SQL syntax but how do I get the 51 and so on to be displayed on the second page.
     
  2. descalzo

    descalzo Grim Squeaker Community Support

    Messages:
    9,375
    Likes Received:
    327
    Trophy Points:
    83
    The term you should Google is "pagination" ... along with terms like PHP and mySQL
     
    • Informative Informative x 1
  3. andylpsx

    andylpsx New Member

    Messages:
    29
    Likes Received:
    1
    Trophy Points:
    3
    Thank you, I will do that.
     

Share This Page