You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and p.dateDebEnligne <= CURRENT_DATE() and p.dateFinEnligne >= CURRENT_DATE()' at line 9
SELECT p.NumPromo numPromo, DATE_FORMAT(p.DateDebut,'%d/%m/%Y') AS ma_date_debut, DATE_FORMAT(p.DateFin,'%d/%m/%Y') AS ma_date_fin, p.frNomPromo, p.frCourteDescriptionPromo, p.frUrlPromo, p.Image_promo
FROM T_CategoriePromo cp
INNER JOIN T_Promo p
ON cp.NumPromo = p.NumPromo
WHERE cp.NumPagesAdmins = and p.dateDebEnligne <= CURRENT_DATE() and p.dateFinEnligne >= CURRENT_DATE()
