SELECT DATE_FORMAT(a.date,"%Y") FROM tbl_news a WHERE UNIX_TIMESTAMP(a.`expiration`) < UNIX_TIMESTAMP(NOW()) AND a.news=1 AND (a.id_unit=1) AND a.publiable LIKE 'oui' AND a.moderateur<>'' AND serveur LIKE '%1%' GROUP By DATE_FORMAT(a.date,"%Y") asc

Les dépêches 2014

lien

Les dépêches 2014

SELECT DATE_FORMAT(a.date,"%Y") FROM tbl_news a WHERE UNIX_TIMESTAMP(a.`expiration`) < UNIX_TIMESTAMP(NOW()) AND a.news=1 AND (a.id_unit=1) AND a.publiable LIKE 'oui' AND a.moderateur<>'' AND serveur LIKE '%1%' GROUP By DATE_FORMAT(a.date,"%Y") asc

 

12-05-2014
04-04-2014
04-02-2014

 

Retour en haut