<?php
$count = 0;
$duel = $tgame->prepare('SELECT szNAME, dwWarriorWin, dwRangerWin, dwArcherWin, dwWizardWin, dwPriestWin, dwSorcererWin FROM TCHARTABLE
RIGHT JOIN TDUELSCORETABLE ON TCHARTABLE.dwCharID = TDUELSCORETABLE.dwCharID ORDER BY szNAME ASC');
$duel->execute();

$data = $duel->fetchAll(PDO::FETCH_ASSOC);
foreach($data as $row) {
   $user_id =  $row['szNAME'];
   $Warrior =  $row['dwWarriorWin'];
   $Ranger =  $row['dwRangerWin'];
   $Archer =  $row['dwArcherWin'];
   $Wizard =  $row['dwWizardWin'];
   $Priest =  $row['dwPriestWin'];
   $Sorcerer =  $row['dwSorcererWin'];
   $All = $row['dwWarriorWin'] +  $row['dwRangerWin'] +  $row['dwArcherWin'] + $row['dwWizardWin'] + $row['dwPriestWin'] + $row['dwSorcererWin'];
   $count++;

   echo '
        <tr><center>
        <td>'.$user_id.'</td>
        <td style="color:#ff3232">'.$Warrior.'</td>
		<td style="color:#00f5ff">'.$Ranger.'</td>
		<td style="color:#32cd32">'.$Archer.'</td>
		<td style="color:#9f79ee">'.$Wizard.'</td>
		<td style="color:#ffb90f">'.$Priest.'</td>
		<td style="color:#76eec6">'.$Sorcerer.'</td>
        </tr>';
}
   echo '</tbody></table></center>';
?>