[SOLVED] problem selecting a date greater than todays

[shadiadiph]

Hi i am trying to select articles from the database where the date has a higher value than todays date?

 

$todaysdate = date("Y:m:d");
$sql="select * from tbldetails where enddate= '>$todaysdate' order by dtadded desc";

 

[Festy]

$todaysdate = date("Y:m:d");
$sql="select * from tbldetails where enddate > $todaysdate order by dtadded desc";

[shadiadiph]

awesome thanks but i had to change the date to $todaysdate = date("Y-m-d");