displaying rows where datestamp is not empty (0000-00-00)

[gopanthers]

I have a simple database table that has a field entry for when somebody's membership expires. Most entries have no date entered, which automatically becomes "0000-00-00" in that field. To simply display all people who have ever had any membership expiration date entered into the database, the following code works fine:

$query = "SELECT * FROM table WHERE field != '0000-00-00' ORDER BY lastname";

But can somebody please tell me how to do the more complicated task of only displaying rows with datestamp values that are greater than today's date and therefore always in the future (an ever changing date, but 2012-06-03 as of this posting).

Thanks.

[Derokorian]

SELECT * FROM table WHERE field > CURDATE()

[gopanthers]

sweet awesomeness. Thanks! 🙂