selecting by dates

[stefke]

what's the correct mysql string for selecting

all courses that start today + the next 30 days?

SELECT * from COURSE where STARTDATE=>systemdate and STARTDATE=<systemdate+30

or is this not possible and do we need to this in php?

any help will be greatly appreciated

[aaronott]

depending how you have the date in the database. if you have the date in there as yyyy-mm-dd you could do something like this:

SELECT * FROM course WHERE startdate <= CURDATE() AND startdate >= (SELECT DATE_SUB(CURDATE(), INTERVAL 30 DAY))

basically this says get all info from course where startdate is greater or equal to today AND startdate is less than or equal to today + 30 days.

The other option is to set a $startdate and $enddate using php. Either way is up to you.

I've not tested this but it should work.