Hi,
I'm trying to echo only the upcoming ads in a table but is jumping like 4 ads
The database field is a TIMESTAMP
2008-04-15 08:57:29
2008-04-15 11:53:27
2008-04-15 16:24:48
2008-04-16 08:58:15
At this time Tuesday, April 15, 2008 / 9:19 AM was only showing 2008-04-16 08:58:15 Not showing 2008-04-15 11:53:27 and 2008-04-15 16:24:48 the are before.
Here's my SQL statement I can see whats wrong can someone help me with this
SELECT ads.ad_id, ads.ad_date, source.source FROM ads LEFT JOIN source ON ads.ad_source = source.source_id WHERE ads.ad_date >= NOW()