从最近30天获取mysql结果 [英] Getting mysql result from the last 30 days

问题描述

可能重复:
从数据库获取但仅持续30天

Possible Duplicate:
Get from database but only last 30 days

我有一些php代码，用于计算最近30天中数据库中的行.问题是，如果我更改一段代码，以使数字从-30更改为-20，则输出数字将从272变为360，而不是下降.

Hi I have some php code which I use to count the rows in a database from the last 30 days. The problem is, that if I change the piece of code so that the number changes from -30 to -20, the output number goes from 272 to 360 instead of going down.

这是代码:

$result = mysql_query("SELECT * FROM all_count WHERE DATEDIFF(date,NOW()) = -30 and member ='000002'");
$num_rows60 = mysql_num_rows($result);

推荐答案

尝试一下

select * from `table` where `yourfield` >= DATE_SUB(CURDATE(), INTERVAL 3 MONTH)

年份，年份请参见以下示例.

For days, year see below for example.

DATE_SUB(CURDATE(), INTERVAL 15 DAY) /*For getting record specific days*/

DATE_SUB(CURDATE(), INTERVAL 1 YEAR) /*for getting records specific years*/

---

对于Anand，查询

---

For Anand, query

BETWEEN DATE_SUB( CURDATE( ) ,INTERVAL 6 MONTH ) AND DATE_SUB( CURDATE() ,INTERVAL 3 MONTH ) 
/* For Getting records between last 6 month to last 3 month

这篇关于从最近30天获取mysql结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！