Doing something wrong with DATES

[cmason22]

i have a database of records with a date field in format YYYY-MM-DD.

i am trying to grab all entries that have dates in the future.

$today= date("Y-m-d");

$fetch= "SELECT id, DATE_FORMAT(date, '%M %D, %Y') as long_date, title from tablename where date > $today ORDER BY date DESC limit 5"; //GRAB THE LIST

the results are strange, giving entries with older dates. any idea what im doing wrong?

[stolzyboy]

can you give an example of what $today holds in a specific query, along with the results of the query?

[Installer]

Try

...date > '$today'...

or

...date > CURDATE()...

[cmason22]

thanks!

'$today' did the trick.