$_SESSION['TicketGagnant']="oui";$_SESSION['KodeGagnant']=$_POST['InputUtiliserKode'];$sql = "CREATE TEMPORARY TABLE tmp TYPE=HEAP SELECT id, nom, 1 / valeur * stock_en_cours UnSur FROM kados";$req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());$sql = "CREATE TEMPORARY TABLE tmp2 TYPE=HEAP SELECT sum(UnSur) AS total FROM tmp";$req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());$sql = "SELECT a.id, a.nom, a.UnSur / b.total *100 AS chances FROM tmp a, tmp2 b ORDER BY RAND()";$req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());$valeur_tiree_au_sort = mt_rand(1,100);$valeur_intermediare = 0;echo "DEBUG: Notre valeur tirée au sort est : $valeur_tiree_au_sort<br>";while($data = mysql_fetch_assoc($req)) { if($valeur_tiree_au_sort<=$valeur_intermediare){ $_SESSION['KadoID']=$data['id']; $_SESSION['KadoNom']=$data['nom']; echo "DEBUG: $valeur_tiree_au_sort est plus petit que $valeur_intermediare<br>"; print("vous avez gagné : "); print($_SESSION['KadoNom']); exit; } else { echo "DEBUG: val interm. = $valeur_intermediare<br>"; $val_intermediaire+=$data['chances']; echo "DEBUG: val interm. = $valeur_intermediare<br>"; echo "DEBUG: on passe à la prochaine ligne<br>"; }}