Double permanent

Règlement

Résultats

[insert_php]
$mysql_link = mysql_connect("mysql51-58.pro","emesetw-1","hVKp5DVpEqg8") or die("pb serveur mysql");
$db_selected=mysql_select_db("emesetw-1",$mysql_link) or die("pb base");

$doubles="SELECT
ta.nom AS nom1, ta.prenom AS prenom1,
tb.nom AS nom2, tb.prenom AS prenom2
FROM `TdoubleParticipants`
left JOIN adherent AS ta ON ta.ident = IdParticipant
left JOIN adherent AS tb ON tb.ident = IdPartenaire ";
//echo $doubles;
$result_doubles=mysql_query($doubles);

echo "
";
echo "
";
echo "

 

 

 

";
echo "

";
$nb_equipe = mysql_num_rows($result_doubles);
echo "

$nb_equipe équipes engagées en double

";
echo "
";
while ($liste=mysql_fetch_object($result_doubles))
{
echo "

";
echo "

";
echo "

";
echo "

";
}
echo "

Equipes
$liste->nom1 ".utf8_encode($liste->prenom1)." $liste->nom2 ".utf8_encode($liste->prenom2)."

";

[/insert_php]