[SOLVED] selecting dates between now and 31 days later

[digitalgod]

hey guys,

 

I'm trying to verify events that will start between curdate() and 31 days later.

 

so far this is my query but it doesn't seem to work

 

SELECT id, main_image FROM events WHERE member_id = '$_SESSION[members_id]' AND DATE_ADD(CURDATE() ,INTERVAL 31 DAY) >= start

 

where start is the date and time of when the event starts. I keep getting events that have already passed with that query and I don't understand why...  I just need to select all dates that start between now and 31 days later... any ideas??

[accident]

you forgot to add in the check for greater then today...

so shoudl be

SELECT id, main_image FROM events WHERE member_id = '$_SESSION[members_id]' AND DATE_ADD(CURDATE() ,INTERVAL 31 DAY) >= start AND start > CURDATE()

[accident]

err should be start >= CURDATE()

[digitalgod]

thanks accident, can't believe I didn't see that...

 

note to self, sleep more!