[SOLVED] Only displaying after the current date

[tomhoad]

Hi,

 

My query for an events page is as follows:

 

$query   = "SELECT id, venue, FROM_UNIXTIME(date, '%d/%m/%Y') as dttm, tickets FROM events WHERE date >= NOW() ORDER BY date";

 

But it returns nothing at all (no errors though). How can I get it to only select the gigs from todays date (i.e. not displaying past gigs).

 

Simple I'm sure, but I'm inexperienced!

 

Cheers.

[gregor171]

WHERE date >= NOW()

Would show all the dates in the future and NOW (at this moment).

 

WHERE date <= NOW()

[Ken2k7]

$query = "SELECT id, venue, FROM_UNIXTIME(date, '%d/%m/%Y') as dttm, tickets FROM events WHERE TIME_FORMAT(date, '%Y-%m-%d') = CURDATE() ORDER BY date";

[tomhoad]

Thanks for the replies! Neither quite worked, but pointed me in the right direction.

 

For future reference:

 

$query   = "SELECT id, venue, FROM_UNIXTIME(date, '%d/%m/%Y') as dttm, tickets FROM events WHERE  FROM_UNIXTIME(date, '%Y-%m-%d') > CURDATE() ORDER BY date";