Padekite del eiliskumo

[popilas]

Sveiki, zodziu viskas kaip ir veikia tiktai kazkodel nera eiliskumo 

tarkim 

1. Name 20 kills
2. Name 30 Kills
3. Name 25 kills

Isdelioja ne pagaleiliskuma

$query = $dbcon->query("SELECT COUNT(game_team.username), SUM(kills) as kills, game_team.team FROM `game_team` 
RIGHT JOIN game_player ON game_team.username = game_player.username
GROUP BY `team` HAVING COUNT(game_team.username) > 2 ORDER BY game_player.kills DESC LIMIT 15");

 

[Vidmantas.]

nežinau ar padės 

ORDER BY game_player.kills DESC

pakeisk į

ORDER BY max(game_player.kills) DESC

[popilas]

ne tik kaikurie vietom susikeite, bet vistiek eiliskumo nera ;/