从最近30天获取mysql结果

本文介绍了从最近30天获取mysql结果的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

可能重复: 从数据库获取但仅持续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