http://handnoeux.free.fr/exemple_affichage_tableau.php
Voici mon code php qui permet un affichage comme cela : [/url]http://handnoeux.free.fr/exemple_affich ... ur.php[url]
echo "<tr><td colspan=\"2\">$row[3] $row[1]/$row[2], $row[0], $row[4] ".FICHE_BUTS."</td></tr>";
}
echo "<tr><td colspan=\"2\" align=\"right\"><a href=\"?id_joueur=$id_joueur&details_buts=1\">".FICHE_DETAIL."</a><br></td></tr>";
echo '<table border=0 width=500 class="tablephpl2" cellspacing="0" cellpadding="0"><tr bgcolor="#678440" ><td width="100%" height=:"26" colspan="2">';
}
else
{
$requete="SELECT cldom.nom AS cldom, clext.nom AS clext, phpl_matchs.buts_dom, phpl_matchs.buts_ext, date_reelle, dom.id AS eqdom, ext.id AS eqext, phpl_journees.numero, phpl_championnats.id as id_champ, phpl_divisions.nom, phpl_saisons.annee, (phpl_saisons.annee)+1, phpl_matchs.id as id_match
FROM phpl_equipes AS dom, phpl_equipes AS ext, phpl_matchs, phpl_journees, phpl_clubs AS cldom, phpl_clubs AS clext, phpl_buteurs, phpl_effectif, phpl_championnats, phpl_divisions, phpl_saisons
WHERE phpl_matchs.id_equipe_dom = dom.id
AND phpl_matchs.id_equipe_ext = ext.id
AND dom.id_club = cldom.id
AND ext.id_club = clext.id
AND phpl_matchs.id_journee = phpl_journees.id
AND phpl_buteurs.id_match = phpl_matchs.id
AND phpl_buteurs.id_effectif = phpl_effectif.id
AND phpl_effectif.id_joueur = '$id_joueur'
AND phpl_championnats.id_division=phpl_divisions.id
AND phpl_championnats.id_saison=phpl_saisons.id
AND phpl_championnats.id = ext.id_champ
AND phpl_championnats.id = dom.id_champ
ORDER BY annee, date_reelle ASC";
$id_champ=0;
$resultats=mysql_query($requete) or die (mysql_error());
while ($row=mysql_fetch_array($resultats))
{
if (!($id_champ=="$row[8]")) {echo "<tr><td>".FICHE_BUTS."</td>";}
else {echo "<tr><td></td>";}
echo "<td>".ADMIN_JOURNEES_MSG9."$row[7] : $row[0] <a href=\"match.php?id_match=$row[id_match]\">$row[2] - $row[3]</a> $row[1] </td></tr>";
$id_champ=$row[8];
}
}
if (!isset($_GET["details_stats"]))
{
$requete="SELECT phpl_clubs.nom, phpl_saisons.annee, (phpl_saisons.annee)+1, phpl_divisions.nom, Sum(phpl_compo.matchs) AS Total, phpl_championnats.id AS id_champ, phpl_matchs.date_reelle as date
FROM phpl_clubs, phpl_effectif, phpl_saisons, phpl_divisions, phpl_championnats, phpl_compo, phpl_joueurs, phpl_equipes, phpl_matchs
WHERE phpl_championnats.id_saison=phpl_saisons.id
AND phpl_championnats.id_division=phpl_divisions.id
AND phpl_equipes.id_champ=phpl_championnats.id
AND phpl_equipes.id_club=phpl_clubs.id
AND phpl_compo.id_effectif=phpl_effectif.id
AND phpl_effectif.id_joueur=phpl_joueurs.id
AND phpl_effectif.id_equipe=phpl_equipes.id
AND phpl_matchs.id=phpl_compo.id_match
AND phpl_joueurs.id='$id_joueur'
GROUP by id_champ, phpl_clubs.nom
ORDER by annee desc, date desc";
$resultats=mysql_query($requete) or die (mysql_error());
while ($row=mysql_fetch_array($resultats))
{
echo "<tr><td colspan=\"2\">$row[3] $row[1]/$row[2], $row[0], $row[4] ".FICHE_STATS."</td></tr>";
}
echo "<tr><td colspan=\"2\" align=\"right\"><a href=\"?id_joueur=$id_joueur&details_stats=1\">".FICHE_DETAIL2."</a><br></td></tr>";
echo '<table border=0 width=500 class="tablephpl2" cellspacing="0" cellpadding="0"><tr bgcolor="#678440" ><td width="100%" height=:"26" colspan="2">';
}
else
{
$requete="SELECT cldom.nom AS cldom, clext.nom AS clext, phpl_matchs.buts_dom, phpl_matchs.buts_ext, date_reelle, dom.id AS eqdom, ext.id AS eqext, phpl_journees.numero, phpl_championnats.id as id_champ, phpl_divisions.nom, phpl_saisons.annee, (phpl_saisons.annee)+1, phpl_matchs.id as id_match
FROM phpl_equipes AS dom, phpl_equipes AS ext, phpl_matchs, phpl_journees, phpl_clubs AS cldom, phpl_clubs AS clext, phpl_compo, phpl_effectif, phpl_championnats, phpl_divisions, phpl_saisons
WHERE phpl_matchs.id_equipe_dom = dom.id
AND phpl_matchs.id_equipe_ext = ext.id
AND dom.id_club = cldom.id
AND ext.id_club = clext.id
AND phpl_matchs.id_journee = phpl_journees.id
AND phpl_compo.id_match = phpl_matchs.id
AND phpl_compo.id_effectif = phpl_effectif.id
AND phpl_effectif.id_joueur = '$id_joueur'
AND phpl_championnats.id_division=phpl_divisions.id
AND phpl_championnats.id_saison=phpl_saisons.id
AND phpl_championnats.id = ext.id_champ
AND phpl_championnats.id = dom.id_champ
ORDER BY annee, date_reelle ASC";
$id_champ=0;
$resultats=mysql_query($requete) or die (mysql_error());
while ($row=mysql_fetch_array($resultats))
{
if (!($id_champ=="$row[8]")) {echo "<tr><td>".FICHE_STATS." :</td>";}
else {echo "<tr><td></td>";}
echo "<td>".ADMIN_JOURNEES_MSG9."$row[7] : $row[0] <a href=\"match.php?id_match=$row[id_match]\">$row[2] - $row[3]</a> $row[1] </td></tr>";
$id_champ=$row[8];
}
}
if (!isset($_GET["details_stats2"]))
{
$requete="SELECT phpl_clubs.nom, phpl_saisons.annee, (phpl_saisons.annee)+1, phpl_divisions.nom, Sum(phpl_compo2.remp) AS Total, phpl_championnats.id AS id_champ, phpl_matchs.date_reelle as date
FROM phpl_clubs, phpl_effectif, phpl_saisons, phpl_divisions, phpl_championnats, phpl_compo2, phpl_joueurs, phpl_equipes, phpl_matchs
WHERE phpl_championnats.id_saison=phpl_saisons.id
AND phpl_championnats.id_division=phpl_divisions.id
AND phpl_equipes.id_champ=phpl_championnats.id
AND phpl_equipes.id_club=phpl_clubs.id
AND phpl_compo2.id_effectif=phpl_effectif.id
AND phpl_effectif.id_joueur=phpl_joueurs.id
AND phpl_effectif.id_equipe=phpl_equipes.id
AND phpl_matchs.id=phpl_compo2.id_match
AND phpl_joueurs.id='$id_joueur'
GROUP by id_champ, phpl_clubs.nom
ORDER by annee desc, date desc";
$resultats=mysql_query($requete) or die (mysql_error());
while ($row=mysql_fetch_array($resultats))
{
echo "<tr><td colspan=\"2\">$row[3] $row[1]/$row[2], $row[0], $row[4] ".FICHE_STATS2."</td></tr>";
}
echo "<tr><td colspan=\"2\" align=\"right\"><a href=\"?id_joueur=$id_joueur&details_stats2=1\">".FICHE_DETAIL3."</a><br></td></tr>";
echo '<table border=0 width=500 class="tablephpl2" cellspacing="0" cellpadding="0"><tr bgcolor="#678440" ><td width="100%" height=:"26" colspan="2">';
}
else
{
$requete="SELECT cldom.nom AS cldom, clext.nom AS clext, phpl_matchs.buts_dom, phpl_matchs.buts_ext, date_reelle, dom.id AS eqdom, ext.id AS eqext, phpl_journees.numero, phpl_championnats.id as id_champ, phpl_divisions.nom, phpl_saisons.annee, (phpl_saisons.annee)+1, phpl_matchs.id as id_match
FROM phpl_equipes AS dom, phpl_equipes AS ext, phpl_matchs, phpl_journees, phpl_clubs AS cldom, phpl_clubs AS clext, phpl_compo2, phpl_effectif, phpl_championnats, phpl_divisions, phpl_saisons
WHERE phpl_matchs.id_equipe_dom = dom.id
AND phpl_matchs.id_equipe_ext = ext.id
AND dom.id_club = cldom.id
AND ext.id_club = clext.id
AND phpl_matchs.id_journee = phpl_journees.id
AND phpl_compo2.id_match = phpl_matchs.id
AND phpl_compo2.id_effectif = phpl_effectif.id
AND phpl_effectif.id_joueur = '$id_joueur'
AND phpl_championnats.id_division=phpl_divisions.id
AND phpl_championnats.id_saison=phpl_saisons.id
AND phpl_championnats.id = ext.id_champ
AND phpl_championnats.id = dom.id_champ
ORDER BY annee, date_reelle ASC";
$id_champ=0;
$resultats=mysql_query($requete) or die (mysql_error());
while ($row=mysql_fetch_array($resultats))
{
if (!($id_champ=="$row[8]")) {echo "<tr><td>".FICHE_STATS2." :</td>";}
else {echo "<tr><td></td>";}
echo "<td>".ADMIN_JOURNEES_MSG9."$row[7] : $row[0] <a href=\"match.php?id_match=$row[id_match]\">$row[2] - $row[3]</a> $row[1] </td></tr>";
$id_champ=$row[8];
}
}
if (!isset($_GET["details_CJ"]))
{
$requete="SELECT phpl_clubs.nom, phpl_saisons.annee, (phpl_saisons.annee)+1, phpl_divisions.nom, Sum(phpl_compoCJ.CJ) AS Total, phpl_championnats.id AS id_champ, phpl_matchs.date_reelle as date
FROM phpl_clubs, phpl_effectif, phpl_saisons, phpl_divisions, phpl_championnats, phpl_compoCJ, phpl_joueurs, phpl_equipes, phpl_matchs
WHERE phpl_championnats.id_saison=phpl_saisons.id
AND phpl_championnats.id_division=phpl_divisions.id
AND phpl_equipes.id_champ=phpl_championnats.id
AND phpl_equipes.id_club=phpl_clubs.id
AND phpl_compoCJ.id_effectif=phpl_effectif.id
AND phpl_effectif.id_joueur=phpl_joueurs.id
AND phpl_effectif.id_equipe=phpl_equipes.id
AND phpl_matchs.id=phpl_compoCJ.id_match
AND phpl_joueurs.id='$id_joueur'
GROUP by id_champ, phpl_clubs.nom
ORDER by annee desc, date desc";
$resultats=mysql_query($requete) or die (mysql_error());
while ($row=mysql_fetch_array($resultats))
{
echo "<tr><td colspan=\"2\">$row[3] $row[1]/$row[2], $row[0], $row[4] ".FICHE_CJ."</td></tr>";
}
echo "<tr><td colspan=\"2\" align=\"right\"><a href=\"?id_joueur=$id_joueur&details_CJ=1\">".FICHE_DETAIL4."</a><br></td></tr>";
echo '<table border=0 width=500 class="tablephpl2" cellspacing="0" cellpadding="0"><tr bgcolor="#678440" ><td width="100%" height=:"26" colspan="2">';
}
else
{
$requete="SELECT cldom.nom AS cldom, clext.nom AS clext, phpl_matchs.buts_dom, phpl_matchs.buts_ext, date_reelle, dom.id AS eqdom, ext.id AS eqext, phpl_journees.numero, phpl_championnats.id as id_champ, phpl_divisions.nom, phpl_saisons.annee, (phpl_saisons.annee)+1, phpl_matchs.id as id_match
FROM phpl_equipes AS dom, phpl_equipes AS ext, phpl_matchs, phpl_journees, phpl_clubs AS cldom, phpl_clubs AS clext, phpl_compoCJ, phpl_effectif, phpl_championnats, phpl_divisions, phpl_saisons
WHERE phpl_matchs.id_equipe_dom = dom.id
AND phpl_matchs.id_equipe_ext = ext.id
AND dom.id_club = cldom.id
AND ext.id_club = clext.id
AND phpl_matchs.id_journee = phpl_journees.id
AND phpl_compoCJ.id_match = phpl_matchs.id
AND phpl_compoCJ.id_effectif = phpl_effectif.id
AND phpl_effectif.id_joueur = '$id_joueur'
AND phpl_championnats.id_division=phpl_divisions.id
AND phpl_championnats.id_saison=phpl_saisons.id
AND phpl_championnats.id = ext.id_champ
AND phpl_championnats.id = dom.id_champ
ORDER BY annee, date_reelle ASC";
$id_champ=0;
$resultats=mysql_query($requete) or die (mysql_error());
while ($row=mysql_fetch_array($resultats))
{
if (!($id_champ=="$row[8]")) {echo "<tr><td>".FICHE_CJ." :</td>";}
else {echo "<tr><td></td>";}
echo "<td>".ADMIN_JOURNEES_MSG9."$row[7] : $row[0] <a href=\"match.php?id_match=$row[id_match]\">$row[2] - $row[3]</a> $row[1] </td></tr>";
$id_champ=$row[8];
}
}
if (!isset($_GET["details_CR"]))
{
$requete="SELECT phpl_clubs.nom, phpl_saisons.annee, (phpl_saisons.annee)+1, phpl_divisions.nom, Sum(phpl_compoCR.CR) AS Total, phpl_championnats.id AS id_champ, phpl_matchs.date_reelle as date
FROM phpl_clubs, phpl_effectif, phpl_saisons, phpl_divisions, phpl_championnats, phpl_compoCR, phpl_joueurs, phpl_equipes, phpl_matchs
WHERE phpl_championnats.id_saison=phpl_saisons.id
AND phpl_championnats.id_division=phpl_divisions.id
AND phpl_equipes.id_champ=phpl_championnats.id
AND phpl_equipes.id_club=phpl_clubs.id
AND phpl_compoCR.id_effectif=phpl_effectif.id
AND phpl_effectif.id_joueur=phpl_joueurs.id
AND phpl_effectif.id_equipe=phpl_equipes.id
AND phpl_matchs.id=phpl_compoCR.id_match
AND phpl_joueurs.id='$id_joueur'
GROUP by id_champ, phpl_clubs.nom
ORDER by annee desc, date desc";
$resultats=mysql_query($requete) or die (mysql_error());
while ($row=mysql_fetch_array($resultats))
{
echo "<tr><td colspan=\"2\">$row[3] $row[1]/$row[2], $row[0], $row[4] ".FICHE_CR."</td></tr>";
}
echo "<tr><td colspan=\"2\" align=\"right\"><a href=\"?id_joueur=$id_joueur&details_CR=1\">".FICHE_DETAIL5."</a><br></td></tr>";
echo '<table border=0 width=500 class="tablephpl2" cellspacing="0" cellpadding="0"><tr bgcolor="#678440" ><td width="100%" height=:"26" colspan="2">';
}
else
{
$requete="SELECT cldom.nom AS cldom, clext.nom AS clext, phpl_matchs.buts_dom, phpl_matchs.buts_ext, date_reelle, dom.id AS eqdom, ext.id AS eqext, phpl_journees.numero, phpl_championnats.id as id_champ, phpl_divisions.nom, phpl_saisons.annee, (phpl_saisons.annee)+1, phpl_matchs.id as id_match
FROM phpl_equipes AS dom, phpl_equipes AS ext, phpl_matchs, phpl_journees, phpl_clubs AS cldom, phpl_clubs AS clext, phpl_compoCR, phpl_effectif, phpl_championnats, phpl_divisions, phpl_saisons
WHERE phpl_matchs.id_equipe_dom = dom.id
AND phpl_matchs.id_equipe_ext = ext.id
AND dom.id_club = cldom.id
AND ext.id_club = clext.id
AND phpl_matchs.id_journee = phpl_journees.id
AND phpl_compoCR.id_match = phpl_matchs.id
AND phpl_compoCR.id_effectif = phpl_effectif.id
AND phpl_effectif.id_joueur = '$id_joueur'
AND phpl_championnats.id_division=phpl_divisions.id
AND phpl_championnats.id_saison=phpl_saisons.id
AND phpl_championnats.id = ext.id_champ
AND phpl_championnats.id = dom.id_champ
ORDER BY annee, date_reelle ASC";
$id_champ=0;
$resultats=mysql_query($requete) or die (mysql_error());
while ($row=mysql_fetch_array($resultats))
{
if (!($id_champ=="$row[8]")) {echo "<tr><td>".FICHE_CR." :</td>";}
else {echo "<tr><td></td>";}
echo "<td>".ADMIN_JOURNEES_MSG9."$row[7] : $row[0] <a href=\"match.php?id_match=$row[id_match]\">$row[2] - $row[3]</a> $row[1] </td></tr>";
$id_champ=$row[8];
}
}
echo "</table><br></div>";
}
// on ferme la connexion à mysql
mysql_close();
?>
Pouvez vous m'aider ?[/url]