MySQL query

[deliriousthunder]

Hi,

I have a database table which contains records of a list of events, obviously there are several properties related to each event, one of which is the "Start Date".

For a page on my site I need to query that table, and display a list of the events which haven't yet started, (i.e. upcoming events).

In the table, the field type in the database table is date, so I figure there must be an easy way to query it so that it only returns events which haven't started yet.

Just looking for a hint really, haven't tried it or researched it yet.

Thanks,
Thomas

[jthayne]

Use the MySQL CURDATE() function. For example:

SELECT * FROM my_table WHERE `StartDate` > CURDATE();