/* Semaine en cours */
<WRAP center centeralign 200px>
<sql>
SELECT 
CONCAT(
CASE
  WHEN WEEKDAY (datep) = 0 Then "Lundi"
  WHEN WEEKDAY (datep) = 1 Then "Mardi"
  WHEN WEEKDAY (datep) = 2 Then "Mercredi"
  WHEN WEEKDAY (datep) = 3 Then "Jeudi"
  WHEN WEEKDAY (datep) = 4 Then "Vendredi"
  WHEN WEEKDAY (datep) = 5 Then "Samedi"
  ELSE "Dimanche"
END,
" ",DAY(datep),"<br/>",
"De ",TIME_FORMAT(datep,"%H h %i"), 
" à ",TIME_FORMAT (datep2,"%H h %i"),
"<br/>",label,
"<br/>",note
) as 'Aujourd''hui'
/* ,`location` */ 
FROM `llx89_actioncomm` 
WHERE code = 'ANIMATION'
AND DATE(NOW()) = DATE(datep)
Order by datep
</sql>
</WRAP>