Pb avec select ... from ... where

18 sept. 2010, 14:44

Bonjour tout le monde,

Voila, j'ai un code qui m'affiche des résultats de match

<h1>MATCH CoD World At War</h1>

<?php 

        $cnx = mysql_connect("base", "nom", "pass");
        $db = mysql_select_db("WGKS_TEAM");

$sqlresultmatch=mysql_query("SELECT warid , score_team, score_adv FROM nuked_match WHERE game='2' and etat='1'");
$nb_matchs=mysql_num_rows($sqlresultmatch);
$nb_victoirematchs=0;
$nb_losematchs=0;
$exeacomatchs=0;
while(list($warid, $score_team, $score_adv)= mysql_fetch_array($sqlresultmatch))

{
    if ($score_team>$score_adv){
    $nb_victoirematchs++;
	}
	else if ($score_team<$score_adv){
    $nb_losematchs++;
	}
	else{
    $exeacomatchs++;
	}
}
echo"
<table width=\"100%\" border=\"0\" cellspacing=\"1\" cellpadding=\"2\" align=\"center\"> 
<br><TD align=\"center\" bgcolor=\"#009900\"><small><b>Victoire : $nb_victoirematchs</b></td> 
<TD align=\"center\"  bgcolor=\"#3333FF\"><small><b>Match nul : $exeacomatchs</b></td>
<TD align=\"center\"  bgcolor=\"#990000\"><small><b>Défaite : $nb_losematchs</b></td></table> 
<TABLE width=\"100%\" cellpadding=\"2\" cellspacing=\"1\">"; 
 
echo( "</table><br>\n" );

echo"<table width=\"100%\" border=\"1\" cellspacing=\"0\" cellpadding=\"2\"><tr>
	   <td width=\"20%\" bgcolor=\"$bgcolor3\" align=\"center\"><b>".Date."</b></td>
	   <td width=\"15%\" bgcolor=\"$bgcolor3\" align=\"center\"><b>".Team."</b></td>
	   <td width=\"40%\" bgcolor=\"$bgcolor3\" align=\"center\"><b>".Type."</b></td>
	   <td width=\"15%\" bgcolor=\"$bgcolor3\" align=\"center\"><b>".Résultat."</b></td>
	   <td width=\"10%\" bgcolor=\"$bgcolor3\" align=\"center\"><b>".Détails."</b></td></tr>
	   </table>
	 
	 <table width=\"100%\" border=\"1\" cellspacing=\"1\" cellpadding=\"3\">";

	$sql=mysql_query("SELECT warid, adversaire, pays_adv, url_adv, type, date_jour, date_mois, date_an, score_team, score_adv FROM nuked_match WHERE game='2' and etat='1' ORDER BY date_an DESC, date_mois DESC, date_jour DESC LIMIT 100"); 
	while (list($warid, $adv_name, $adv_url, $pays_adv, $type, $jour, $mois, $an, $score_team, $score_adv) = mysql_fetch_array($sql)){
	$adv_name=stripslashes($adv_name);
if ($score_team>$score_adv){$color="#009900";}
	else if ($score_team<$score_adv){$color="#990000";}
	else{$color="#3333FF";}

echo"	<tr><td width=\"20%\" align=\"center\">$jour/$mois/$an</td>
	<td width=\"15%\" align=\"left\"><img src=\"http://wgks.team.free.fr/images/flags/$adv_url\">";
				 
	if ($pays_adv!="")
        {
	echo" <width=\"10%\" align=\"left\"><a href=\"$pays_adv\" target=\"_blank\" style=\"text-decoration:none\">$adv_name</a>";
        }
	else
        {
         echo"$adv_name";
        }
				 
echo"	</td><td width=\"40%\" align=\"center\">$type</td>
	<td width=\"15%\" bgcolor=\"$color\"  align=\"center\"><font color=\"#FFFFFF\"><B>$score_team/$score_adv</B></font>
	</td><td width=\"10%\" align=\"center\"><a href=\"http://wgks.team.free.fr/wgk/index.php?option=com_php&Itemid=21\"><img src=\"http://wgks.team.free.fr/images/report.gif\"></a></td></tr>";
	}
echo"	</table>";



	$sql=mysql_query("SELECT warid, type, adversaire, score_team, score_adv, pays_adv FROM nuked_match where etat='1' ORDER BY date_an DESC, date_mois DESC, date_jour DESC LIMIT 5"); 
	while (list($war_id, $type, $adv_name, $score_team, $score_adv, $pays_adv) = mysql_fetch_array($sql)){
 	$adv_name=stripslashes($adv_name);

	if ($score_team>$score_adv){$color="#009900";}
	else if ($score_team<$score_adv){$color="#990000";}
	else{$color="#3333FF";}
	
 
	}
	
$sqlresultmatch=mysql_query("SELECT warid , score_team, score_adv FROM nuked_match WHERE game='2' and etat='1'");
$nb_matchs=mysql_num_rows($sqlresultmatch);
$nb_victoirematchs=0;
$nb_losematchs=0;
$exeacomatchs=0;
while(list($warid, $score_team, $score_adv)= mysql_fetch_array($sqlresultmatch))
{
    if ($score_team>$score_adv){
    $nb_victoirematchs++;
	}
	else if ($score_team<$score_adv){
    $nb_losematchs++;
	}
	else{
    $exeacomatchs++;
	}
}
echo"
<table width=\"100%\" border=\"0\" cellspacing=\"1\" cellpadding=\"2\" align=\"center\"> 
<br><TD align=\"center\" bgcolor=\"#009900\"><small><b>Victoire : $nb_victoirematchs</b></td> 
<TD align=\"center\"  bgcolor=\"#3333FF\"><small><b>Match nul : $exeacomatchs</b></td>
<TD align=\"center\"  bgcolor=\"#990000\"><small><b>Défaite : $nb_losematchs</b></td></table> 
<TABLE width=\"100%\" cellpadding=\"2\" cellspacing=\"1\">"; 
 
echo( "</table><br>\n" );

Qui marche très bien
voir le résultat ici

Dans la derniere colonne j'ai les détails du match qui sont placé sur le même "warid" que les résultats du match, mais quand je clique dessus, ça m'envoie sur ce code mais rien ne s'affiche voir ICI

Code : Tout sélectionner

<?php 

////titre page////

        $cnx = mysql_connect("base", "nom", "pass");
        $db = mysql_select_db("WGKS_TEAM");
        $sql = "SELECT warid, team, adversaire, url_adv, pays_adv, date_jour, date_mois, date_an, type, style, score_team, score_adv, map_1, map_2, map_3, report, player1, player1kill, player1kia, player2, player2kill, player2kia, player3, player3kill, player3kia, player4, player4kill, player4kia, player5, player5kill, player5kia, player6, player6kill, player6kia,  auteur, url_league from nuked_match where warid = '$warid' " ;
        $requete = mysql_query($sql, $cnx);

while( $result = mysql_fetch_array( $requete ) )
{

echo( "<tr>\n" );
echo( "<td><div border=\"1\" align=\"center\">WGKs VS ".$result["adversaire"]."</div></td>\n" );
echo( "</tr>\n" );
}

 
echo( "</table><br>\n" );

////détail match////

        $cnx = mysql_connect("base", "nom", "pass");
        $db = mysql_select_db("WGKS_TEAM");
        $sql = "SELECT warid, team, adversaire, url_adv, pays_adv, date_jour, date_mois, date_an, type, style, score_team, score_adv, map_1, map_2, map_3, report, player1, player1kill, player1kia, player2, player2kill, player2kia, player3, player3kill, player3kia, player4, player4kill, player4kia, player5, player5kill, player5kia, player6, player6kill, player6kia,  auteur, url_league from nuked_match where warid = '$warid' " ;
        
        $requete = mysql_query($sql, $cnx);

echo( "<table border=\"0\" width=\"100%\" cellpadding=\"1\" cellspacing=\"1\" align=\"center\">\n" );

while( $result = mysql_fetch_array( $requete ) )
{

echo( "<tr>\n" );
echo( "<td><div align=\"left\">Adversaire : ".$result["adversaire"]."</div></td>\n" );
echo( "</tr>\n" );
echo( "<tr>\n" );
echo( "<td ><div align=\"left\">Date : ".$result["date_jour"]."-".$result["date_mois"]."-".$result["date_an"]."</div></td>\n" );
echo( "</tr>\n" );
echo( "<tr>\n" );
echo( "<td ><div align=\"left\">Type : ".$result["type"]."</div></td>\n" );
echo( "</tr>\n" );
echo( "<tr>\n" );
echo( "<td ><div align=\"left\">Style : ".$result["style"]."</div></td>\n" );
echo( "</tr>\n" );
echo( "<tr>\n" );
echo( "<td ><div align=\"left\">Map : ".$result["map_1"]." - ".$result["map_2"]."</div></td>\n" );
echo( "</tr>\n" );
echo( "<tr>\n" );
echo( "<td ><div align=\"left\">Résultats : ".$result["score_team"]." - ".$result["score_adv"]."</div></td>\n" );
echo( "</tr>\n" );
}
 
echo( "</table><br>\n" );

////détail joueurs////

        $cnx = mysql_connect("base", "nom", "pass");
        $db = mysql_select_db("WGKS_TEAM");
        $sql = "SELECT warid, team, adversaire, url_adv, pays_adv, date_jour, date_mois, date_an, type, style, score_team, score_adv, map_1, map_2, map_3, report, player1, player1kill, player1kia, player2, player2kill, player2kia, player3, player3kill, player3kia, player4, player4kill, player4kia, player5, player5kill, player5kia, player6, player6kill, player6kia,  auteur, url_league from nuked_match where warid = '$warid' " ;
        $requete = mysql_query($sql, $cnx);

echo( "<table border=\"1\" width=\"100%\" cellpadding=\"1\" cellspacing=\"1\" align=\"center\">\n" );
echo( "<tr>
<td bgcolor=\"#3f3e3e\" width=\"50\"><div align=\"center\">joueurs</div></td>
<td bgcolor=\"#3f3e3e\" width=\"25\"><div align=\"center\">kills</div></td>
<td bgcolor=\"#3f3e3e\" width=\"25\"><div align=\"center\">Dieds</div></td>
</tr>" );
 
while( $result = mysql_fetch_array( $requete ) )
{

echo( "<tr>\n" );
echo( "<td><div align=\"center\">".$result["player1"]."</div></td>\n" );
echo( "<td><div align=\"center\">".$result["player1kill"]."</div></td>\n" );
echo( "<td><div align=\"center\">".$result["player1kia"]."</div></td>\n" );
echo( "</tr>\n" );

echo( "<tr>\n" );
echo( "<td><div align=\"center\">".$result["player2"]."</div></td>\n" );
echo( "<td><div align=\"center\">".$result["player2kill"]."</div></td>\n" );
echo( "<td><div align=\"center\">".$result["player2kia"]."</div></td>\n" );
echo( "</tr>\n" );

echo( "<tr>\n" );
echo( "<td><div align=\"center\">".$result["player3"]."</div></td>\n" );
echo( "<td><div align=\"center\">".$result["player3kill"]."</div></td>\n" );
echo( "<td><div align=\"center\">".$result["player3kia"]."</div></td>\n" );
echo( "</tr>\n" );

echo( "<tr>\n" );
echo( "<td><div align=\"center\">".$result["player4"]."</div></td>\n" );
echo( "<td><div align=\"center\">".$result["player4kill"]."</div></td>\n" );
echo( "<td><div align=\"center\">".$result["player4kia"]."</div></td>\n" );
echo( "</tr>\n" );

echo( "<tr>\n" );
echo( "<td><div align=\"center\">".$result["player5"]."</div></td>\n" );
echo( "<td><div align=\"center\">".$result["player5kill"]."</div></td>\n" );
echo( "<td><div align=\"center\">".$result["player5kia"]."</div></td>\n" );
echo( "</tr>\n" );

echo( "<tr>\n" );
echo( "<td><div align=\"center\">".$result["player6"]."</div></td>\n" );
echo( "<td><div align=\"center\">".$result["player6kill"]."</div></td>\n" );
echo( "<td><div align=\"center\">".$result["player6kia"]."</div></td>\n" );
echo( "</tr>\n" );

echo( "<tr>\n" );
echo( "<td><div align=\"center\">".$result["player7"]."</div></td>\n" );
echo( "<td><div align=\"center\">".$result["player7kill"]."</div></td>\n" );
echo( "<td><div align=\"center\">".$result["player7kia"]."</div></td>\n" );
echo( "</tr>\n" );

echo( "<tr>\n" );
echo( "<td><div align=\"center\">".$result["player8"]."</div></td>\n" );
echo( "<td><div align=\"center\">".$result["player8kill"]."</div></td>\n" );
echo( "<td><div align=\"center\">".$result["player8kia"]."</div></td>\n" );
echo( "</tr>\n" );
}
 
echo( "</table><br>\n" );

Alors que si manuellement je met un chiffre à la place du $warid, j'ai les bons résultats qui s'affichent.
Dans le 2eme code, je dois faire comment pour afficher le détail correspondant à la sélection demandé.

J'espere que vous avez bien compris

Bon aprem

18 sept. 2010, 15:01

Il faut que tu passes la variable warid dans l'url, sinon ta requête ne va pas l'inventer pour toi.

Ensuite pour la récupérer dans ton script :

$warid = $_GET['warid'];

18 sept. 2010, 15:52

Merci pour la réponse, mais je vois pas trop comment mettre $warid dans l'url.
Je continue de chercher, mais si quelqu'un à une piste, je prends volontier.

Merci

18 sept. 2010, 16:47

Bon tâchons de garder notre calme...

echo"   </td><td width=\"40%\" align=\"center\">$type</td>
   <td width=\"15%\" bgcolor=\"$color\"  align=\"center\"><font color=\"#FFFFFF\"><B>$score_team/$score_adv</B></font>
   </td><td width=\"10%\" align=\"center\"><a href=\"http://wgks.team.free.fr/wgk/index.php?option=com_php&Itemid=21&warid=$warid\"><img src=\"http://wgks.team.free.fr/images/report.gif\"></a></td></tr>";

Voici le lien modifié avec le passage de la variable.

Bien beh au final je t'ai tout codé, dommage que tu n'ai pas collé à ta signature.

Pb avec select ... from ... where

Qui est en ligne