PHPfrance

la communauté d'entraide francophone dédiée au PHP

Pb avec select ... from ... where

Répondre


Cette question est un moyen d’empêcher des soumissions automatisées de formulaires par des robots.
Smileys
:D :) :( :o :shock: :? 8-) :lol: :x :P :oops: :cry: :evil: :twisted: :roll: :wink: :!: :?: :idea: :arrow: :| :mrgreen: =D> #-o =P~ :^o :non: :priere: 8-|
Voir plus de smileys
  Revue du sujet
 

  Étendre la vue Revue du sujet : Pb avec select ... from ... where

Re: Pb avec select ... from ... where

par xTG » 18 sept. 2010, 16:47

:shock:
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. :)

Re: Pb avec select ... from ... where

par coucou » 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

Re: Pb avec select ... from ... where

par xTG » 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'];

Pb avec select ... from ... where

par coucou » 18 sept. 2010, 14:44

Bonjour tout le monde,

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

Code : Tout sélectionner

<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 :P
Bon aprem