$_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>";
	}
	
}