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?
$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.