[PHP-WIN] Query to MySQL

[Marlene Burckhalter]

I am trying to display an event calendar in an html document ( I am a beginner, I had 
to start small).
My problem is the following query displays all the records instead of just the ones 
with the event date greater than or equal to the current date.

Any suggestions to a begginer?  Here is a snipplet:

 $query = "SELECT eventmonth FROM $create_calendar_tablename
             WHERE eventdate >= 'currentdate()'
             LIMIT 19";
   $result = mysql_query($query);
   if(!$result) error_message(sql_error());
   while($query_data = mysql_fetch_array($result)) {
   echo $query_data["eventmonth"],"<P>";
   }