Trying to get all id's whose DateTime records are 15 minutes from now
Posted on 2013-06-16
I'm setting up a cron function running every 15 minutes that checks a column called 'scheduled' for datetimes that are 15 minutes from now and retrieves each campaign_id so I can send out a reminder email about that upcoming campaign.
Records can be saved in 15 minute values only, for example:
2013-06-13 11:00:00 or 2013-06-13 11:15:00 or 2013-06-13 11:30:00 or 2013-06-13 11:45:00
Any idea what a query may look like?
mysql_query("SELECT campaign_id FROM messaging WHERE scheduled = ???...");
Any help would be much appreciated.