Smarty

[kiruban]

Bonjour,

[php:1:2202b71564]$cado = array();
$querychamp = mysql_query("SELECT date, time, nom, prenom, titre
FROM gagnant g, membre m, jeuxcompteur j
WHERE g.gagnant = m.id_membre
AND g.cadeaux = j.id",$db);
$num = mysql_num_rows($querychamp);
if ( $num != 0) {
while($champ = mysql_fetch_assoc($querychamp)){
array_push ($cado, $champ);
}
$smarty->assign('cado',$cado);
}
$smarty->display('gagnants.tpl');
[/php:1:2202b71564]

[ciboulette]

[kiruban]

merci beaucoup

reference JULIEN T.