1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
| $tabClassement = array();
$tabRep = array(0, 1, 2, 3, 2, 3, 1, 2, 2, 3, 3, 2, 1, 2, 1, 1, 2, 1, 3, 3, 2);
$req_gagnants = $ewp->sqlQuery("SELECT * FROM ".QVISA." GROUP BY mnemo ORDER BY id");
while ($gagnant = $ewp->sqlGetObj($req_gagnants))
{
$nbOK = 0;
for ($k=1; $k<21; $k++)//vérification des réponses
if ($gagnant->{'r'.$k} == $tabRep[$k])
$nbOK++;
$tabClassement[] = array("note" => $nbOK, "nom" => $gagnant->mnemo);
}
rsort($tabClassement);
foreach($tabClassement as $cle => $tableau)
foreach($tableau as $note => $mnemo)
echo $note.' - '.$mnemo.'<br />'; |
Partager