1. The forums will be archived and moved to a read only mode in about 2 weeks (mid march).

Solved Pager

Discussion in 'Development' started by Teamblocket, Jan 4, 2018.

  1. Teamblocket

    Teamblocket Zombie

    Messages:
    301
    GitHub:
    teamblocket
    How can i create a page so like people can do /topmoney 3 and page 3 will pop up, am using SQLite3 to store the money.
     
    OnTheVerge likes this.
  2. SOFe

    SOFe Administrator Staff Member PMMP Team Poggit Admin

    Messages:
    1,968
    GitHub:
    sof3
    https://stackoverflow.com/a/14068871/3990767

    For instance, SELECT name, money FROM player_money ORDER BY money DESC LIMIT $N OFFSET $M
    where $N = rows-per-page, $M = $N * (page number - 1) where page number starts at 1
     
    Last edited: Jan 5, 2018
  3. Teamblocket

    Teamblocket Zombie

    Messages:
    301
    GitHub:
    teamblocket
    Thanks:):D
     
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.