Trying to query a season in mySQL

[watson50]

I'm trying to define queries which show different chunks of output depending on whether it is Spring, Summer, Winter or Fall. Right now I have 4 queries similar to the following:

$query = "SELECT monthname(e_DateStart) as eMonth, dayofweek(e_DateStart) as eDay, e_DateTitle, subeTitle, subeDesc
FROM events, subevent
WHERE events.e_dateId = subevent.e_dateId
AND e_DateStart >= '2003-06-21' && e_DateStart < '2003-09-21'
ORDER BY e_DateStart";

This works for Summer, but every year I would have to update the year from 2003 to 2004 for all four of the queries.

Is there a mySQL date function that would update the year for me? I should also ask if there is generally a better way to go about doing this. 😕

Thanks in advance for any help you can provide.

Lucas

[kevinsequeira]

$query = "SELECT monthname(e_DateStart) as eMonth, dayofweek(e_DateStart) as eDay, e_DateTitle, subeTitle, subeDesc
FROM events, subevent
WHERE events.e_dateId = subevent.e_dateId
AND e_DateStart >= '".date("Y")."-06-21' && e_DateStart < '".date("Y")."-09-21'
ORDER BY e_DateStart"; 

reg
kevin

[watson50]

Thanks for the quick response. 🙂

For Winter then, since that overlaps years could I put something like:

AND e_DateStart >= '".date("Y")."-12-21' && e_DateStart < '".date_add(date("Y"), INTERVAL 1 YEAR)."-03-21'

Lucas