";
$titre="S'informer sur un tournoi";
include("enTete.php");
$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.id_club ,tournoi.debut,tournoi.fin,tournoi.id_tournoi,tournoi.saison,tournoi.engagement
FROM club,tournoi
WHERE tournoi.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=$[''];
$type="";$deja_vu=0;
//if (mktime(20,0,0,$fin[1],$fin[2],$fin[0])-time()>0){
$requete2="SELECT type FROM categorie WHERE categorie.tournoi=$[''] GROUP BY type ;";
$reponse2=mysql_query($requete2,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
");
while($reptab2=mysql_fetch_array($reponse2)){
if ($deja_vu){$type=$type.',';}
else {$deja_vu=1;}
$type=$type.$[''];
}
$debut=explode("-",$['']);
$fin=explode("-",$['']);
$[''][]=$[''];
$[''][]=$[''];
$[''][]=$debut[2]."/".$debut[1]."/".$debut[0];
$[''][]=$fin[2]."/".$fin[1]."/".$fin[0];
$[''][]=$type;
$[''][]=$contact;
//}
}
mysql_close($db_connection);
echo "
| Club | Debut du tournoi | Fin du tournoi | Type | Contact |
";
for ($i=0;$i".$[''][$i]." | ".$[''][$i]." | ".$[''][$i]." | ".$[''][$i]." | ".$[''][$i]." | ";
}
echo "
";
include("piedDePage.php");?>