查询获取排名

SELECT
    *
FROM 
(
    SELECT t1.*,@rank:=@rank+1 AS RANK
    FROM
    (SELECT * FROM act_wishcard ORDER BY donationAmount DESC) t1,(SELECT @rank:=0) t2
) t
ORDER BY t.RANK ASC;

参考

mysql 查询获取排名的方法（绝对有效）