需要执行两次ORDER BY，排名问题

Question

I have been struggling to set this up for months and months! I need help with setting rank to my database.

This is how my current code looks like:

$db->queryNoReturn("SET @a:=0");
return $db->query("
    SELECT * FROM
        (SELECT 
                `FFA_Stats`.`id`, 
                `FFA_Stats`.`player_uuid`,
                `FFA_Stats`.`points`,
                `FFA_Stats`.`hits`,
                `FFA_Stats`.`shots`,
                `FFA_Stats`.`wins`,
                `FFA_Stats`.`tkills`, 
                `FFA_Stats`.`tdeaths`, 
                (`FFA_Stats`.`tkills`/`FFA_Stats`.`tdeaths`) as `KDR`, 
                `player`.`name`, 
                `player`.`uuid`, 
                `player`.`online`, 
                (@a:=@a+1) AS rank
            FROM `FFA_Stats`
            INNER JOIN `player` ON `FFA_Stats`.`player_uuid`=`player`.`uuid`
            ORDER BY `points` DESC
        ) AS `sub`
    ");

Basically its sorting it by points and you can check how it looks like here: http://filipvlaisavljevic.com/clash/ffa.php

All I want to do is add rank to the sorted table so the player with the most points would be #1 etc.

Does anyone know what to do?

Answer 1

Usually a rank number would be an integer that you could generate from iterating through the rows of the query result. eg. echo $count++;

If you have calculated or attributed a rank in your database then you can add 'order by' statements separated by commas. eg.

    FROM `FFA_Stats`
    INNER JOIN `player`
    ON `FFA_Stats`.`player_uuid`=`player`.`uuid`
    ORDER BY `rank` DESC, `points` DESC) AS `sub`
        ");