// S'affiche seulement si il éxiste un sondage au moins if(MysqlExistance("Sondage")) { // Récupération aléatoire du sondage $Requete = mysql_query("SELECT ID FROM Sondage WHERE Lang=\"$Lang\" ORDER BY ID DESC LIMIT 3"); $V=array(); while($Row=mysql_fetch_array($Requete)) { $V[count($V)]=$Row["ID"]; } mysql_free_result($Requete); $TID=$V[array_rand($V)]; unset($V); // Récupération du texte $Requete=mysql_query("SELECT * FROM Sondage WHERE ID=\"$TID\""); $Question = mysql_result($Requete,0,"Question"); $Nb=1; while($Nb<=4) { $Reponse[$Nb] = mysql_result($Requete,0,"Reponse$Nb"); $Nb++; } if(isset($_COOKIE["IDS"])) { $IDS=$_COOKIE["IDS"]; } else { $IDS=array(); } if(!isset($IDS[$TID])) { $IDS[$TID]=false; } if(($IDS[$TID])||(isset($MontrerResultat))) { //Recupération des résultats $Requete = mysql_query("SELECT * FROM SondageVote WHERE ID=\"$TID\""); $NbVote = mysql_result($Requete,0,"NbVote"); $Nb=1; while($Nb<=4) { if($NbVote<="0") { $TauxReponse[$Nb]="0"; } else { $TauxReponse[$Nb] = mysql_result($Requete,0,"TauxReponse$Nb"); $TauxReponse[$Nb] = $TauxReponse[$Nb]*100; $TauxReponse[$Nb] = $TauxReponse[$Nb]/$NbVote; $TauxReponse[$Nb] = number_format($TauxReponse[$Nb], 2, ',', ' '); } $Nb++; } //Affichage des résultats echo "
$Question
$NbVote votes.
";
$Nb=1;
while($Nb<=count($Reponse))
{
echo '- ' . $Reponse[$Nb] . ' : ' . $TauxReponse[$Nb] . '%
';
$Nb++;
}
echo "
$ChErMysqlLireExistance
"; } ?>