从NOW或LATER（不是将来的时间戳）中选择记录

Question

How do I do this?

I have the table "news" and I want the page to show only news created from now are later My idea is to pre-write news so article with timestamp 2011-12-18 12:00 will automatically appear on sunday noon

shouldn´t it be like

$select = mysql_query("SELECT * FROM news WHERE timestamp is NOW() or LATER ORDER BY timestamp");

Any ideas?

Answer 1

$select = mysql_query("SELECT * FROM news WHERE timestamp <= NOW() ORDER BY timestamp");

try that...

Keep in mind - your post suggests you're not using a timestamp. You appear to be using a datetime datatype. My answer would work for datetime.

Also, I think your title is misleading. By your question it looks like you're making a queue so things will be posted by the date you provide. If in the future, then it does not display the article until that date.