Skip to content
Advertisement

Tag: paging

How can I improve my query so it takes less time to execute, and I can still divide the result into pages using multiple tables

I am trying to create a PHP website that would allow users to see a leaderboard of online game players by their ranking. The ranking consists of following components: Rank (Challenger, Grandmaster, Master, Diamond, Platinum, Gold, Silver, Bronze and Iron) Tier (I, II, III and IV) League points (an integer number) Each rank consists of 4 tiers, except for Challenger,

Advertisement