Re: Query to MySQL

I bet you it's the ' around the currentdate()-function that causes it to interpret it as a string instead of a function call. And afaik there is no currentdate()-function in mysql, it's now(). At 15:02 2002-09-25 -0400, Marlene Burckhalter wrote:

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>"; }