";
echo $J1 ." : " .$score_total_J1 ." victoires";
echo "
";
echo $J2 ." : " .$score_total_J2 ." victoires";
if($score_total_nul != 0)
{
echo "
";
echo $score_total_nul ." match nul";
}
}
//$sql = "SELECT * FROM parties WHERE w_name = '".$J1."' and b_name = '".$J2."' or w_name = '".$J2."' and b_name = '".$J1."' ORDER by date desc " ;
//$sql = "SELECT * FROM parties_new WHERE w_name = '".$J1."' and b_name = '".$J2."' or w_name = '".$J2."' and b_name = '".$J1."' ORDER by date desc " ;
$sql = "SELECT * FROM " .$_SESSION['parties'] ." WHERE w_name = '".$J1."' and b_name = '".$J2."' or w_name = '".$J2."' and b_name = '".$J1."' ORDER by date desc " ;
//$sql = "SELECT * FROM " .$_SESSION['parties'] ." WHERE w_name = " .$J1 ." and b_name = " .$J2 ." or w_name = " .$J2 ." and b_name = " .$J1 ." ORDER by date desc " ;
//$sql = "SELECT * FROM parties_new " ." WHERE w_name = " .$J1 ." and b_name = " .$J2 ." or w_name = " .$J2 ." and b_name = " .$J1 ." ORDER by date desc " ;
//echo $sql;
//$sql = "SELECT * FROM " .$_SESSION['parties'] ." WHERE w_name = '".$J1."' and b_name = '".$J2."' or w_name = '".$J2."' and b_name = '".$J1."' ORDER by date desc ";
$results = mysql_query($sql);
$n = mysql_num_rows($results);
if($n != 0)
{
?>
";
}
/*
$sql = "SELECT * FROM partie WHERE joueur1 = '".$J1."'";
$results1 = mysql_query($sql);
$sql = "SELECT * FROM partie WHERE joueur2 = '".$J1."'";
$results2 = mysql_query($sql);
$n1 = mysql_num_rows($results1);
$n2 = mysql_num_rows($results2);
$number = $n1 + $n2;
echo "Nombre de réponses: " .$number;
if($number != 0)
{
echo '';
echo '
| Joueur 1 |
Joueur 2 |
Résultat |
Score |
Date |
Heure |
';
while($data = mysql_fetch_assoc($results1))
{
$J1 = $data['joueur1'];
$J2 = $data['joueur2'];
$resultat_partie = $data['resultat_partie'];
$score = $data['score_joueur1'];
$date = $data['date_partie'];
$heure = $data['heure_partie'];
echo "
| $J1 |
$J2 |
$resultat_partie |
$score |
$date |
$heure |
";
}
while($data = mysql_fetch_assoc($results2))
{
$J1 = $data['joueur1'];
$J2 = $data['joueur2'];
$resultat_partie = $data['resultat_partie'];
$score = $data['score_joueur2'];
$date = $data['date_partie'];
$heure = $data['heure_partie'];
echo "
| $J2 |
$J1 |
$resultat_partie |
$score |
$date |
$heure |
";
}
echo "
";
echo '
';
}
*/
?>