Récapitulation des récompenses
Concours International du Meilleur boudin
ANNEE
CONCOURS 2023
//phpinfo();
?>
//phpinfo();
$conect=mysql_connect ("sql.boudin-mortagne.com","boudinmortagneco","Atxx-731") or die ("connexion impossible");
mysql_query("SET NAMES 'utf8'");
mysql_selectdb("boudinmortagneco",$conect);
echo "
";
//répartition récompenses
echo"Soit Pour la FRANCE :";
echo "
";
$req = mysql_query("SELECT ecodeprix,libeleprix, COUNT(*) as nbre FROM echantillon where ezoneorigine < 10 AND ecodeprix < 8 AND ecodeprix >0 GROUP BY ecodeprix")or die(mysql_error());
while ($donnees = mysql_fetch_array($req)) {
echo $donnees['libeleprix']." = ".$donnees['nbre']."
";
}
echo "
";
//TOTAL
echo"TOTAL DES DIPLOMES FRANCE :";
//echo "
";
$req = mysql_query("SELECT ecodeprix,libeleprix, COUNT(*) as nbre FROM echantillon where ezoneorigine < 10 AND ecodeprix < 8 AND ecodeprix >0")or die(mysql_error());
while ($donnees = mysql_fetch_array($req)) {
//echo $donnees['libeleprix']." = ".$donnees['nbre']."
";
echo $donnees['nbre']."
";
}
echo "
";
echo "
";
echo"Soit Pour les étrangers :";
echo "
";
$req = mysql_query("SELECT ecodeprix,libeleprix, COUNT(*) as nbre FROM echantillon where ezoneorigine > 10 AND ecodeprix < 8 AND ecodeprix >0 GROUP BY ecodeprix")or die(mysql_error());
while ($donnees = mysql_fetch_array($req)) {
echo $donnees['libeleprix']." = ".$donnees['nbre']."
";
}
echo "
";
echo "
";
//TOTAL
echo"TOTAL DES DIPLOMES ETRANGERS :";
//echo "
";
$req = mysql_query("SELECT ecodeprix,libeleprix, COUNT(*) as nbre FROM echantillon where ezoneorigine > 10 AND ecodeprix < 8 AND ecodeprix >0")or die(mysql_error());
while ($donnees = mysql_fetch_array($req)) {
//echo $donnees['libeleprix']." = ".$donnees['nbre']."
";
echo $donnees['nbre']."
";
}
echo "
";
//TOTAL
echo"TOTAL GOBAL :";
//echo "
";
$req = mysql_query("SELECT ecodeprix,libeleprix, COUNT(*) as nbre FROM echantillon where ezoneorigine > 0 AND ecodeprix < 8 AND ecodeprix >0")or die(mysql_error());
while ($donnees = mysql_fetch_array($req)) {
//echo $donnees['libeleprix']." = ".$donnees['nbre']."
";
echo $donnees['nbre']."
";
}
mysql_close($conect);
?>