}
echo "<tr><td colspan=\"8\"><br /><input type=\"hidden\" name=\"go\" value=\"1\">\n <center><input type=\"submit\" value=" . ENVOI . "></td></tr></table>";
echo "<br /><br />";
$query = "SELECT url_logo FROM phpl_clubs WHERE id='{$id}'";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result)) {
echo "<center><img src=\"{$row['0']}\"><br /><br /><br /><br />";
}
$query = "SELECT phpl_classe.nom, phpl_classe.id FROM phpl_classe order by rang";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result)) {
echo "<table class=tablephpl2 cellspacing=\"0\" align=center width=\"90%\">";
echo "<tr class=phpl3><td><b><font color=\"#FFFFFF\">{$row['0']}</font></b></td></tr>";
$id_classe = $row[1];
echo "<td><table cellspacing=\"0\"><tr><td><font face=\"arial\" size=\"2\">";
$aff_rens = aff_rens($id_classe, $id);
echo "{$aff_rens}</font>";
echo "</tr></td>";
echo "</table></td></table><br /><br />";
}
echo "<table class=tablephpl2 cellspacing=\"0\" align=center width=\"90%\"><tr class=phpl3><td><b><font color=\"#FFFFFF\">" . CONSULT_CLUB_3 . "</font></b></td></tr>";
$query = "SELECT annee, phpl_divisions.nom, phpl_championnats.id, phpl_equipes.id\n FROM phpl_saisons, phpl_championnats, phpl_divisions, phpl_clubs, phpl_equipes\n WHERE phpl_equipes.id_champ=phpl_championnats.id\n AND id_division=phpl_divisions.id\n AND phpl_clubs.id=id_club\n AND phpl_equipes.id_club='{$id}'\n AND phpl_saisons.id=phpl_championnats.id_saison order by annee desc";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result)) {
echo "<tr><td>";
echo "<tr class=phpl2><td><center>{$row['0']}/" . ($row[0] + 1) . " ({$row['1']})</td></tr>";
echo "<tr><td><a href=\"../consult/classement.php?champ={$row['2']}&type=G%E9n%E9ral\">" . CONSULT_CLUB_1 . "</a></td></tr>";
echo "<tr><td><a href=\"../consult/detaileq.php?champ={$row['2']}&equipe={$row['3']}\">" . CONSULT_CLUB_2 . "</a><br /><br /></td></tr>";
echo "</td></tr>";
}
echo "</table><br /><br />";
echo "</form></div>";
} else {
$id_clubs = $_REQUEST['id_clubs'];
$champ = $_REQUEST['champ'];
$query = "SELECT id, url_logo FROM phpl_clubs WHERE id='{$id_clubs}'";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
echo "<div align=\"center\"><img src=\"{$row['1']}\" alt=\"\"></div><br /><br /><br /><br />";
$query = "SELECT phpl_classe.nom, phpl_classe.id FROM phpl_classe order by rang";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result)) {
echo "<table class=\"tablephpl2\" cellspacing=\"0\" align=\"center\" width=\"90%\">";
echo "<tr class=\"trphpl3\"><td align=\"center\"><b>{$row['0']}</b></td></tr>";
$id_classe = $row[1];
echo "<tr><td><table cellspacing=\"0\"><tr class=\"trphpl\"><td>";
$aff_rens = aff_rens($id_classe, $id_clubs);
echo "{$aff_rens}";
echo "</td></tr></table></td></tr></table>\n";
echo "<br /><br /><br /><br />\n";
}
echo "<table class=\"tablephpl2\" cellspacing=\"0\" align=\"center\" width=\"90%\"><tr class=\"trphpl3\"><td align=\"center\"><b>Effectif</b></td></tr><tr><td>";
$query = "SELECT phpl_equipes.id FROM phpl_equipes, phpl_clubs \n WHERE phpl_clubs.id='{$id_clubs}' AND id_champ='{$champ}' AND phpl_clubs.id=phpl_equipes.id_club";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
$equipe = $row[0];
$requete = "SELECT position_terrain\nFROM phpl_joueurs\nGROUP BY position_terrain desc";
$resultats = mysql_query($requete) or die(mysql_error());
while ($row = mysql_fetch_array($resultats)) {
$row[0] = addslashes($row[0]);
$requete1 = "SELECT nom, prenom, phpl_joueurs.id\n FROM phpl_joueurs, phpl_effectif\n WHERE phpl_joueurs.id=phpl_effectif.id_joueur\n AND phpl_effectif.id_equipe='{$equipe}'\n AND position_terrain='{$row['0']}'";
$resultats1 = mysql_query($requete1) or die(mysql_error());
