Hi,

I'm making a site for my game guild. On the pages i have a section where upcoming guild events are displayed with the following query:

SELECT * from events ORDER BY month, day LIMIT 4

The values for month are 1-12 (Jan-Dec) and the values for day are 1-31. Year is not posted so irrelevant to this code at the moment.
The values are posted with a html form, <select> (<option>) to be exact. I'm new to SQL/PHP and couldn't think of another way to post future dates into the sql database.

The question is: What syntax should I add to the query so only todays and future events are diplayed on the page?
I have tried the following but it gives a syntax error:

SELECT * from events ORDER BY month, day WHERE month>=DATEPART(m, GETDATE()) LIMIT 4
(haven't tried the day filter cuz I couldn't get the month filter to work)

Any help would be appreciated.