Query("select * from b_comm as a, bieres as b where a.biere_id = b.id order by a.date desc"); while ($b->NextRow()) { $comm = ereg_replace ("~","?",$b->Get("comm")); $subject = ereg_replace ("~","?",$b->Get("subject")); $xtpl->assign("BIERE_ID",$b->Get("biere_id")); $xtpl->assign("NOM",ucfirst($b->Get("nom"))); $xtpl->assign("SUBJECT",$subject); $xtpl->assign("NAME",$b->Get("name")); $xtpl->assign("EMAIL",$b->Get("email")); $xtpl->assign("COMM",$comm); $xtpl->parse("main.comm_list.li"); } $xtpl->parse("main.comm_list"); $xtpl->parse("main.Titre"); include "left.inc.php"; include "right.inc.php"; include "banner.inc.php"; $xtpl->parse("main"); $xtpl->out("main"); ?>