date functions

[hakancs24]

Hello,

I have a invoice in mysql db with printing date. For example 2005-03-28
I have to send a warnung 8 days after printing date. How can i calculate after 8 days?

please help!

[Installer]

Something like this should work:

$query = "SELECT * WHERE DATEDIFF(datefield, CURDATE()) >= 8";