rendered paste body$_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;while($data = mysql_fetch_assoc($req)) { if($valeur_tiree_au_sort<=$valeur_intermediare){ print("Nous avons un kado"); $_SESSION['KadoID']=$data['id']; $_SESSION['KadoNom']=$data['nom']; print("vous avez gagné : "); print($_SESSION['KadoNom']); exit; }else{ echo "$val_intermediaire<br>"; $val_intermediaire+=$data['chances']; } }