| "; echo"Dans cet espace vous pourrez : | |||||||||||
| "; echo " | ";
$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 "
| "; echo " | |||||||||