<?php echo "Valeur du post valider : ".$_POST["ok"]." "; if(isset($_POST["ok"])) { echo "Formulaire validé "; if(isset($_POST["ok"]) AND isset($_POST['equipier'])) { $equipier = htmlentities($_POST['equipier']); $fight=mysql_query("select Fightvalue from stats WHERE Clodo="".$equipier."" ") or die('Erreur SQL ! '.$fight.mysql_error()); $ligne = mysql_fetch_object($fight); $FightvalueEquipier = $ligne->Fightvalue; $fight2=mysql_query("select Maxi from stats WHERE Clodo AND Type='Adversaire'") or die('Erreur SQL ! '.$fight2.mysql_error()); $ligne1 = mysql_fetch_object($fight2); $FightvalueAdversaire = $ligne1->Maxi; } if(($FightvalueEquipier<$FightvalueAdversaire)) { $sql = "UPDATE stats SET Probabilite='Perdant' WHERE Clodo Type='Adversaire' "; echo "Requete Perdante : ".$sql." "; $requete=mysql_query($sql); } else { $sql = "UPDATE stats SET Probabilite='Gagnant' WHERE Clodo Type='Adversaire' "; echo "Requete Gagnante : ".$sql." "; $requete=mysql_query($sql); }} ?>
<?php //echo "Valeur du post valider : ".$_POST["ok"]." "; if(isset($_POST["ok"])){ echo "Formulaire validé "; if(isset($_POST["ok"]) AND isset($_POST['equipier'])){ $equipier = htmlentities($_POST['equipier']); $fight=mysql_query("select Fightvalue from stats WHERE Clodo="".$equipier."" ") or die('Erreur SQL ! '.$fight.mysql_error()); $ligne = mysql_fetch_object($fight); $FightvalueEquipier = $ligne->Fightvalue; $fight2=mysql_query("select Maxi from stats WHERE Clodo AND Type='Adversaire'") or die('Erreur SQL ! '.$fight2.mysql_error()); $ligne1 = mysql_fetch_object($fight2); $FightvalueAdversaire = $ligne1->Maxi; if(($FightvalueEquipier<$FightvalueAdversaire)){ $sql = "UPDATE stats SET Probabilite='Perdant' WHERE Clodo Type='Adversaire' "; echo "Requete Perdante : ".$sql." "; $requete=mysql_query($sql); } else { $sql = "UPDATE stats SET Probabilite='Gagnant' WHERE Clodo Type='Adversaire' "; echo "Requete Gagnante : ".$sql." "; $requete=mysql_query($sql); } } else { echo ""; } } else {echo "Valeur du post non valider";} ?>
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question<?php //echo "Valeur du post valider : ".$_POST["ok"]." "; if(isset($_POST["ok"])){ echo "Formulaire validé "; if(isset($_POST["ok"]) AND isset($_POST['equipier'])){ $equipier = htmlentities($_POST['equipier']); $fight=mysql_query("select * from stats WHERE Clodo="".$equipier."" limit 1") or die('Erreur SQL ! '.$fight.mysql_error()); $ligne = mysql_fetch_object($fight); echo $FightvalueEquipier = $ligne->Fightvalue ; //verifie la valeur de $FightvalueEquipier $fight2=mysql_query("select * from stats WHERE Clodo AND Type='Adversaire' limit 1") or die('Erreur SQL ! '.$fight2.mysql_error()); $ligne1 = mysql_fetch_object($fight2); echo $FightvalueAdversaire = $ligne1->Maxi ; //verifie la valeur de $FightvalueAdversaire //on teste et on fait la proba // () 2 parenthéses par utiles // j ai supprimé ... // dans la condition qui suit if($FightvalueEquipier<$FightvalueAdversaire){ $sql = "UPDATE stats SET Probabilite='Perdant' WHERE Clodo Type='Adversaire' "; echo "Requete Perdante : ".$sql." "; $requete=mysql_query($sql); } else { $sql = "UPDATE stats SET Probabilite='Gagnant' WHERE Clodo Type='Adversaire' "; echo "Requete Gagnante : ".$sql." "; $requete=mysql_query($sql); } } else { echo ""; } } else {echo "Valeur du post non valider";} ?>