一段时间后隐藏物品[PHP / MySQL]

Question

I want that items hide after the time expired, only today and future items would be shown.

I have code like that now but it doesn't work:

$result = mysql_query("SELECT * FROM table WHERE closing_date >= CURRENT_DATE()");
$numrow = mysql_num_rows($result);

In the MYSQL I have closing_date in that format:

sample: 2014-07-03 20:11:26

So now if time expire item would not be shown on page.

The code don't want work I had tryed many solutions but none didn't work :(

Timeformat must stay same as it is.

Thanks for help!

Answer 1

Replace CURRENT_DATE() with NOW()