$info";
?>
Veuillez choisir le tournoi à administrer
";
include("deco_admin.php");
include("piedDePage.php");
/* sinon si la personne n'est pas autorisé la renvoyer àla page de login */
}
else
{
echo("Non autorisé - Redirection vers la page d'identification dans 2 secondes");
sleep(2);
include("identification_admin.php");
}
function afficher_tableau_tournoi_admin(){
$id_joueur=$_GET['id_joueur'];
$annee_en_cours = date("Y") ;
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 club.nom as nom_club,club.e_mail, club.id_club, club.telephone ,tournoi.debut,tournoi.fin,tournoi.id_tournoi,tournoi.saison,tournoi.nom FROM club,tournoi, juge_arbitre WHERE tournoi.id_club=club.id_club AND tournoi.saison=$annee_en_cours GROUP BY tournoi.debut , club.nom;";
$reponse=mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
");
while($reptab=mysql_fetch_array($reponse)){
$debut=explode("-",$['']);
$fin=explode("-",$['']);
$contact=$[''];
$intitule=$[''];
$type="";
$type_adulte=0;
$type_enfant=0;
$type_double=0;
$requete2="SELECT categorie.type, categorie.age_min, categorie.age_max FROM categorie, categories_par_tournoi WHERE categories_par_tournoi.id_tournoi=$[''] AND categories_par_tournoi.id_categorie=categorie.id_categorie";
$reponse2=mysql_query($requete2,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
");
while($reptab2=mysql_fetch_array($reponse2)){
if($['']=="double")
$type_double=$type_double+1;
else if($['']!="double" && $['']==0)
$type_enfant=$type_enfant+1;
else if($['']!="double" && $['']==0)
$type_adulte=$type_adulte+1;
}
/* affectation des categories */
if($type_adulte>0)
$type=$type."adulte ";
if($type_enfant>0)
$type=$type."jeune ";
if($type_double>0)
$type=$type."double";
$debut=explode("-",$['']);
$fin=explode("-",$['']);
$[''][]=$[''];
$[''][]=$[''];
$[''][]=$debut[2]."/".$debut[1]."/".$debut[0];
$[''][]=$fin[2]."/".$fin[1]."/".$fin[0];
$[''][]=$type;
$[''][]=$contact;
$[''][]=$intitule;
$[''][]=$[''];
}
mysql_close($db_connection);
echo "| Club | Debut du tournoi | Fin du tournoi | Type | Contact | e mail | ";
for ($i=0;$i".$[''][$i]." | | ".$[''][$i]." | ".$[''][$i]." | ".$[''][$i]." | ".$[''][$i]." | ".$[''][$i]." | ".$[''][$i]." |
";
}
echo "