SELECT pp.id_promo FROM promo_prod pp, promo p
WHERE pp.id_prod=
AND pp.id_promo = p.id_promo
AND NOW() BETWEEN p.debut_promo AND p.fin_promo
MySQL error No1064: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 pp.id_promo = p.id_promo
AND NOW() BETWEEN p.debut_promo AND p.fin_promo' at line 3