[SOLVED] only future dates in calendar

[piet]

how would i go about getting only the future dates from this query?

this is for a calendar and i would like to display only future dates including current date or today.

in other words, something like "where date>today"

 

$do=mysql_query ("SELECT id,name,date FROM calendar_events WHERE status='confirmed' ORDER by id DESC");

[revraz]

Add a WHERE and add WHERE date > NOW()

 

And date is your date field

[toplay]

$do=mysql_query ("SELECT `id`, `name`, `date` FROM `calendar_events` WHERE `status` = 'confirmed' AND `date` >= CURDATE() ORDER by `id` DESC");