승점 및 승률 비교해서 랭킹으로 나타내기

sql_query("SELECT mb_id, mb_nick, w, wrate, l, type_title, type_idx, game_type, years, 
(@rank := @rank+1) as rank, (@real_rank := IF (@last > wrate, @real_rank := @real_rank+1, @real_rank) ) as real_rank, 
(@last := wrate) as wrlast FROM ranking_list as a, (SELECT @rank :=0, @last :=0, @real_rank := 1) as b 
order by w desc , wrlast desc limit {$from_record}, {$rows}")

 

rank : 랭킹

wrate : 승률

w : 승리 수

l: 패배 수

 

last에 승률을 넣어서 비교하는 방법