[MySQL] query su date

[flacchio]

MA VIEEEEEEEEEEEENNIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII IIIII

ECCO COME FARE!
Con DAYOFYEAR!!!!!!!!!!!!!!!!!!!!

eccovi la query:

$query = mysql_query("SELECT * FROM utenti1 WHERE DAYOFYEAR(birthdate) BETWEEN DAYOFYEAR(NOW()) AND DAYOFYEAR(NOW() + INTERVAL 7 DAY)");