Améliorer un script

[denisc]

Code PHP :

<?php 

$retour = mysql_query("SELECT COUNT(*) AS nb, SUM(xp) as xp, SUM(victime) as victimes FROM membres WHERE camp='Triple Entente'");

$res = mysql_fetch_array($retour);

$nbsoldats=$res['nb'];

$xp=$res['xp'];

$victimes=$res['victimes'];



$retour = mysql_query("SELECT COUNT(*) AS nb, classe FROM membres WHERE camp='Triple Entente' GROUP BY classe");

while ($res=mysql_fetch_array($retour))

{

  switch($res['classe'])

  {

    case 'Fusilier' : $nbFusilier = $res['nb']; break;

    case 'Infirmier' : $nbInfirmier = $res['nb']; break;

    case 'Artilleur' : $nbArtilleur = $res['nb']; break;

    default : break;

  }

}