仅使用php和time（）显示mysql数据库中的某些项目

Question

Is there a way to only show the items that are older than a certain date in a php mysql array? I'm using this query method and sorting by lastpost_cl:

$query="SELECT * FROM properties ORDER BY lastpost_cl";
$result=mysql_query($query);
$num = mysql_num_rows ($result);
mysql_close();

and I was thinking the way of checking the time would be:

if (time() <= strtotime($lastpost_cl)) {

}

How can I combine the two and only show lastpost_cl that are older that the current time?

Answer 1

$query="SELECT * FROM properties WHERE lastpost_cl < NOW() ".
    "ORDER BY lastpost_cl";

This assumes you're storing the date using one of mysql date types. See the manual here.