Mysql 计算排名

SELECT pm FROM (SELECT A.id,@rank := @rank + 1 AS pm FROM (SELECT id FROM VOTE_postname ORDER BY votenum DESC , id) A, (SELECT @rank := 0) B) M WHERE id=?;