Select Date fields in the future but remove those that have past

[topshelfbleu]

My query is a fixtures list for my local sports team- There seems little point including fixtures from the past as they are in a results query anyway.

I'm ordering by date (see below) but how can I remove the ones already past?

 

$query = "SELECT * FROM fix10 ORDER BY Date";

 

TIA Nick

[Psycho]

Well if your field is a true date field, then this should work

 

$query = "SELECT *
          FROM fix10
          WHERE date >= CURDATE()
          ORDER BY Date";