How to offset query by date?

Asked Jul 31 '15 at 00:05

Active Jul 31 '15 at 00:22

Viewed 48 times

To prevent fraud im looking to offset earnings by 5 days. I pay my users for leads every Friday, basically what i want to do is have the query only to include amounts past last Sunday or past 5 days basically.

This is the query currently in my payments file. $reports = mysql_query("SELECT SUM(rate) as total_earned FROMreportsWHEREstatus= '2' ANDpid= '".$row['id']."'");

I've been reading around here and i got the idea to use where date >= date('2015-12-25');

i have the dates stored as 2015-07-17 01:45:46 so im trying to basically compare the current date.

I tried adding WHERE date > ".date("Y-m-d H:i:s")." - INTERVAL 2 DAY which dont work.

edited Jul 31 '15 at 00:22

asked Jul 31 '15 at 00:05

user2002220

@ciccio the answer is using NOW – user2002220 Jul 31 '15 at 00:15
Have a look at this answer: http://stackoverflow.com/a/3600537/2433843 Also, I suggest you update your code and stop using the now [deprecated](http://php.net/manual/en/function.mysql-query.php) [mysql](http://php.net/manual/en/mysqlinfo.api.choosing.php) – Francesco de Guytenaere Jul 31 '15 at 00:15
It is using NOW minus an INTERVAL. – Francesco de Guytenaere Jul 31 '15 at 00:16
Try `WHERE date < NOW() - INTERVAL 5 DAY` – Francesco de Guytenaere Jul 31 '15 at 00:24
that makes no results show mysql_query("SELECT SUM(rate) as total_earned FROM `reports` WHERE `status` = '2' AND `pid` = '".$row['id']."' AND date < NOW() - INTERVAL 1 DAY)"); – user2002220 Jul 31 '15 at 00:29

How to offset query by date?

0 Answers0