} 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());