if($TicketGain==="oui"){
$_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;
CREATE TEMPORARY TABLE tmp2 TYPE=HEAP SELECT sum(UnSur) AS total FROM tmp;
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){
	$_SESSION['KadoID']=$data['id'];
	$_SESSION['KadoNom']=$data['nom'];}else{
	$val_intermediaire+=$data['chances'];
		}
	
	}