|
- |
".CONSULT_MATCHS."";
echo "";
}
else
{
$color=0;
$query="SELECT divisions.nom, saisons.annee, (saisons.annee)+1
FROM championnats, divisions, saisons
WHERE championnats.id='$champ'
AND divisions.id=championnats.id_division
AND saisons.id=championnats.id_saison";
$result = mysql_query($query);
while ($row=mysql_fetch_array($result))
{
echo "".$row[0]." ".$row[1]."/".$row[2]."";
}
//mysql_free_result($result);
echo "";
$query1="SELECT journees.numero, cldom.nom, clext.nom, matchs.buts_dom, matchs.buts_ext, journees.date_prevue
FROM equipes as dom, equipes as ext, matchs, journees, clubs as cldom, clubs as clext
WHERE matchs.id_equipe_dom=dom.id
AND matchs.id_equipe_ext=ext.id
AND journees.id_champ='$champ'
AND dom.id_club=cldom.id
AND ext.id_club=clext.id
AND matchs.id_journee=journees.id
ORDER BY journees.numero";
$result=mysql_query($query1);
while ($row=mysql_fetch_row($result))
{
if ($row[0]-$x==1)
{
$date = ereg_replace('^([0-9]{2,4})-([0-9]{1,2})-([0-9]{1,2})$','\\3/\\2/\\1', $row[5]);
echo "|
| ".ADMIN_COHERENCE_MSG2." ".$row[0].CONSULT_MATCHS_MSG2.$date."";
}
$x=$row[0];
$bgcolor="#FFFFFF";
if (($color%2)==0) $bgcolor="#E5E5E5";
echo " | ".$row[1]." | ".$row[3]." - | ".$row[4]." | ".$row[2];
$color+=1;
}
//mysql_free_result($result);
echo " | ";
}
include ("apres.php");
?> |
|
|
