date prox settimana

[marketto]

SELECT *
FROM news
WHERE scadenza
BETWEEN CURDATE() AND CURDATE()+ INTERVAL 7 DAY