[text_block text= »<p>[insert_php]</p><p>$hostname="triathlonv303.mysql.db"; //local server name default localhost<br />$username="triathlonv303"; //mysql username default is root.<br />$password="Greenday1"; //blank if no password is set for mysql.<br />$database="triathlonv303"; //database name which you created</p><p>$con=mysql_connect($hostname,$username,$password);</p><p>if(! $con) {<br />die('Connection Failed'.mysql_error());<br />}</p><p>mysql_select_db($database,$con);<br />mysql_query("SET NAMES UTF8");<br />echo'<br />';</p><p>echo '<span style="color: #ffffff;"><b><span style="font-size: large;">Nombre de participants dans les différentes courses : </span></b></span>';<br />echo'<br />';<br />echo'<br />';</p><p>$query = mysql_query("SELECT COUNT(course) FROM inscrits_individuelle_licencie WHERE course='Sprint' and paiement='effectuer'");<br />while($rowtwo = mysql_fetch_array($query)){<br />$NSprintLicencie=$rowtwo['COUNT(course)'];<br />}</p><p>$query = mysql_query("SELECT COUNT(course) FROM inscrits_individuelle_non_licencie WHERE course='Sprint' and paiement='effectuer'");<br />while($rowtwo = mysql_fetch_array($query)){<br />$NSprintNonLicencie=$rowtwo['COUNT(course)'];<br />}<br />$totalNSprint=$NSprintLicencie+$NSprintNonLicencie;</p><p>$query = mysql_query("SELECT COUNT(course) FROM inscrits_individuelle_licencie WHERE course='Découverte' and paiement='effectuer'");<br />while($rowtwo = mysql_fetch_array($query)){<br />$NDecouverteLicencie=$rowtwo['COUNT(course)'];<br />}</p><p>$query = mysql_query("SELECT COUNT(course) FROM inscrits_individuelle_non_licencie WHERE course='Découverte' and paiement='effectuer'");<br />while($rowtwo = mysql_fetch_array($query)){<br />$NDecouverteNonLicencie=$rowtwo['COUNT(course)'];<br />}<br />$totalNDecouverte=$NDecouverteLicencie+$NDecouverteNonLicencie;</p><p>$query = mysql_query("SELECT COUNT(course) FROM inscrits_individuelle_licencie WHERE course='Courte distance' and paiement='effectuer'");<br />while($rowtwo = mysql_fetch_array($query)){<br />$NCourteDistanceLicencie=$rowtwo['COUNT(course)'];<br />}</p><p>$query = mysql_query("SELECT COUNT(course) FROM inscrits_individuelle_non_licencie WHERE course='Courte distance' and paiement='effectuer'");<br />while($rowtwo = mysql_fetch_array($query)){<br />$NCourteDistanceNonLicencie=$rowtwo['COUNT(course)'];<br />}<br />$totalNCourteDistance=$NCourteDistanceLicencie+$NCourteDistanceNonLicencie;</p><p>$query = mysql_query("SELECT COUNT(nomEquipe) FROM inscrits_membre_contre_la_montre WHERE paiement='effectuer'");<br />while($rowtwo = mysql_fetch_array($query)){<br />$NMembreCLM=$rowtwo['COUNT(nomEquipe)'];<br />}</p><p>$query = mysql_query("SELECT COUNT(nomEquipe) FROM inscrits_relais WHERE paiement='effectuer'");<br />while($rowtwo = mysql_fetch_array($query)){<br />$NRelais=$rowtwo['COUNT(nomEquipe)'];<br />}</p><p>echo'<br />';<br />echo'<br />';</p><p>echo'<span style="color: #ffffff;"> Il y a <b>'.$totalNSprint.' </b> participants dans la course Sprint. </span>';<br />echo'<br />';<br />echo'<br />';<br />echo'<span style="color: #ffffff;"> Il y a <b>'.$totalNDecouverte.'</b> participants dans la course Découverte. </span>';<br />echo'<br />';<br />echo'<br />';<br />echo'<span style="color: #ffffff;"> Il y a <b>'.$totalNCourteDistance.' </b> participants dans la course Courte distance. </span>';<br />echo'<br />';<br />echo'<br />';<br />echo'<span style="color: #ffffff;"> Il y a <b>'.$NMembreCLM.' </b> participants dans la course Contre la montre. </span>';<br />echo'<br />';<br />echo'<br />';<br />$placeRelais=$NRelais*3;<br />echo'<span style="color: #ffffff;"> Il y a <b>'.$placeRelais.' </b> participants dans la course Relais. </span>';<br />echo'<br />';<br />echo'<br />';<br />mysql_close($con);<br />echo'<br />';<br />echo'<br />';<br />echo '<span style="color: #ffffff;"><b><span style="font-size: large;">Voici les prix des différentes courses (licencié ou non) : </span></b></span>';<br />[/insert_php]</p><table style="height: 95px;" width="981"><tbody><tr><th><span style="color: #ffffff;">SPRINT</span></th><th><span style="color: #ffffff;">DECOUVERTE</span></th><th><span style="color: #ffffff;">COURTE DISTANCE</span></th><th><span style="color: #ffffff;">CONTRE LA MONTRE</span></th><th><span style="color: #ffffff;">RELAIS</span></th></tr><tr><td><span style="color: #ffffff;"><a href="http://triathlon-cotebasque.com/fr_fr/licence-fftri/" target="_self" rel="noopener"><span style="color: #ffffff;">Licencié = 25 €</span></a></span></td><td><span style="color: #ffffff;"><a href="http://triathlon-cotebasque.com/fr_fr/licence-fftri/" target="_self" rel="noopener"><span style="color: #ffffff;">Licencié = 20 €</span></a></span></td><td><span style="color: #ffffff;"><a href="http://triathlon-cotebasque.com/fr_fr/licence-fftri/" target="_self" rel="noopener"><span style="color: #ffffff;">Licencié = 35 €</span></a></span></td><td><span style="color: #ffffff;"><a href="http://triathlon-cotebasque.com/fr_fr/creation_de_lequipe_contre_la_montre/" target="_self" rel="noopener"><span style="color: #ffffff;">Licencié ou non = 25 €</span></a></span></td><td><span style="color: #ffffff;"><a href="http://triathlon-cotebasque.com/fr_fr/inscription-relais/" target="_self" rel="noopener"><span style="color: #ffffff;">Courte distance = 60 €</span></a></span></td></tr><tr><td><span style="color: #ffffff;"><a href="http://triathlon-cotebasque.com/fr_fr/non-licencies/" target="_self" rel="noopener"><span style="color: #ffffff;">Non licencié = 30 €</span></a></span></td><td><span style="color: #ffffff;"><a href="http://triathlon-cotebasque.com/fr_fr/non-licencies/" target="_self" rel="noopener"><span style="color: #ffffff;">Non licencié = 22 €</span></a></span></td><td><span style="color: #ffffff;"><a href="http://triathlon-cotebasque.com/fr_fr/non-licencies/" target="_self" rel="noopener"><span style="color: #ffffff;">Non licencié = 55 €</span></a></span></td><td><span style="color: #ffffff;">- – – – -</span></td><td><span style="color: #ffffff;"><a href="http://triathlon-cotebasque.com/fr_fr/inscription-relais/" target="_self" rel="noopener"><span style="color: #ffffff;">Découverte = 25 €</span></a></span></td></tr><tr><td><span style="color: #ffffff;">- – – – -</span></td><td><span style="color: #ffffff;">- – – – -</span></td><td><span style="color: #ffffff;">- – – – -</span></td><td><span style="color: #ffffff;">- – – – -</span></td><td><span style="color: #ffffff;"><a href="http://triathlon-cotebasque.com/fr_fr/inscription-relais/" target="_self" rel="noopener"><span style="color: #ffffff;">Sprint = 35 €</span></a></span></td></tr></tbody></table> » _made_with_builder= »true »][/text_block]