pm1122dev의 비밀노트

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 : 승리 ..