Ignore Certain Records Based On Date

[barryflood22]

i have a script which populates all listings in a table and echo's them as nicely laid out records on the front end.

 

i want it to ignore all records which has had its "enddate" passed,

 

below is what i have

 

$sql = "SELECT * FROM $tbl_name ORDER BY dateposted DeSC LIMIT $start, $limit";
$closingdate ="enddate";

 

i want to add something like

 

if $closingdate < todaysdate then ignore;

 

 

any ideas?

[barryflood22]

i worked it out myself :-)

 

$cdate=date("Y-m-d"); // get the current date
$sql = "SELECT * FROM $tbl_name where enddate>='$cdate' ORDER BY dateposted DeSC LIMIT $start, $limit";

[TOA]

*Edit - you found your solution right as I was posting.

Edited October 17, 2012 by TOA

[Barand]

or you could have used the mysql function CURDATE() to give you the current date