LZuDGmTJ

1Mysql query, select from a determined point on
2CREATE TABLE IF NOT EXISTS `ladder_rankings` (
3  `player_id` int(11) NOT NULL,
4  `ladder_points` int(11) NOT NULL,
5  KEY `player_id` (`player_id`)
6) ENGINE=MyISAM DEFAULT CHARSET=latin1;
7	
8SELECT *
9FROM ladder_rankings
10WHERE ladder_points >10
11ORDER BY ladder_points DESC
12LIMIT 5
13	
14SELECT * 
15    FROM (SELECT *
16          FROM ladder_rankings
17          WHERE ladder_points > (SELECT ladder_points 
18                            FROM ladder_rankings 
19                            WHERE player_id = %current_player%)
20          ORDER BY ladder_points ASC
21          LIMIT 5) as NEXT_5
22 ORDER BY ladder_points DESC
23	
24SELECT * FROM (SELECT *
25FROM ladder_rankings
26WHERE ladder_points >10
27ORDER BY ladder_points 
28LIMIT 5) ORDER BY ladder_points DESC