date minus one day

[dachshund]

I have a piece of code which adds up all of the 'views' column from rows added in the past 1 day.

 

I now need a piece of code which adds up all of the 'views' column from rows added the day before that.

 

Any help would be great. Here's my current code.

 

 

 
$sql = mysql_query("SELECT SUM(views) AS sum FROM table_name WHERE `date` >= SUBDATE(CURRENT_DATE, 1)");
 

[requinix]

What you have now looks at things that happened after a day ago. What you need is to look at things that happened after two days ago and before one day ago.

 

Convert that pretty much literally into SQL.

[davidannis]

I think what you have actually looks at yesterday and today. You can look at yesterday only with

$sql = mysql_query("SELECT SUM(views) AS sum FROM table_name WHERE `date` = SUBDATE(CURRENT_DATE, 1)");

or the day before that with

$sql = mysql_query("SELECT SUM(views) AS sum FROM table_name WHERE `date` = SUBDATE(CURRENT_DATE, 2)");

Edited January 16, 2014 by davidannis

[dachshund]

ok i worked it out, it's:

 

 

 
$sql = mysql_query("SELECT SUM(views) AS sum FROM table WHERE `date` >= SUBDATE(CURRENT_DATE, 2) AND `date` <= SUBDATE(CURRENT_DATE, 0)");