57 lines
2.4 KiB
PHP
Executable File
57 lines
2.4 KiB
PHP
Executable File
<?php
|
|
$classement=$_POST['classement'];
|
|
$categorie=$_POST['categorie'];
|
|
$avencement=-1;
|
|
include("conf.php");
|
|
include("mysql_compat.php");
|
|
include ("conf.php");
|
|
$db_connection=mysql_connect($db_host,$db_user,$password);
|
|
mysql_select_db($db_name,$db_connection);
|
|
$requete="SELECT avencement FROM `match` WHERE categorie = '$categorie' GROUP BY avencement ORDER BY avencement DESC;";
|
|
$reponse=mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."<br>");
|
|
while ($reptab=mysql_fetch_array($reponse) and $avencement==-1){
|
|
if ($['']<=$classement)
|
|
$avencement=$[''];
|
|
//echo $classement."*<=*".$['']."<br>";
|
|
}
|
|
if ($avencement > -1){
|
|
$titre="Impression d'un tableau de matchs"; include("enTete.php");
|
|
/////////////////////DEMANDE INFO POUR SAVOIR QUELS TOURS SERONT AFFICHES
|
|
$requete="SELECT tour FROM `match` WHERE categorie = '$categorie' AND avencement='$avencement' GROUP BY tour ORDER BY tour ASC ;";
|
|
$reponse=mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."<br>");
|
|
$i=0;
|
|
while($reptab=mysql_fetch_array($reponse)){
|
|
$list_tour[$i][tour]=$[''];
|
|
$i++;
|
|
}
|
|
mysql_close($db_connection);
|
|
echo "<form action=apercuTableau.php method=post>";
|
|
echo "<center><table width=75%>";
|
|
echo "<tr><td width=30% colspan=2>Quels matchs souhaitez vous imprimer ?</td></tr>";
|
|
echo "<tr><td width=30%>Premier tour affiche : </td><td width=70%><select name=tour_debut>";
|
|
for ($i=0;$i<count($list_tour);$i++){
|
|
$texte= "Tour ".$list_tour[$i][tour];
|
|
echo "<option value=$i>".$texte;
|
|
}echo "</select></td></tr>";
|
|
echo "<tr><td width=30%>Dernier tour affiche : </td><td width=70%><select name=tour_fin>";
|
|
for ($i=0;$i<count($list_tour);$i++){
|
|
$texte="Tour ".$list_tour[$i][tour];
|
|
echo "<option value=$i>".$texte;
|
|
}
|
|
echo "</select></td></tr>";
|
|
echo "</table></center><p>
|
|
<center><INPUT TYPE=SUBMIT VALUE=Continuer>
|
|
<INPUT TYPE=RESET VALUE=Annuler></center>";
|
|
echo "<input type=hidden name=double value='".$double."'>";
|
|
echo "<input type=hidden name=avencement value='".$avencement."'>";
|
|
echo "<input type=hidden name=tour value='".$tour."'>";
|
|
echo "<input type=hidden name=categorie value='".$categorie."'>";
|
|
echo "</form><p>";
|
|
include("piedDePage.php");
|
|
}
|
|
else {
|
|
$erreur="<center><font color=00ff00><h3><b>cette categorie n'est pas entree ds la competition. </b></h3></font></center>";
|
|
include ("quelleAdmin.php");
|
|
}
|
|
?>
|