It's been a long time since I last used PHP, but perhaps something like this would work.
$query = "SELECT TOP 30 Name,Class,cLevel,RESETS,mLevel,Grand_Resets,WinDuels,MapNumber,AccountID from Character where CtlCode < '8' order by Grand_Resets desc, RESETS desc, WinDuels desc";
$rank_char =...