Showing records from previous 30 days

[Crustyfur]

ello,

 

I am struggling with date functions as always and need some help. I just want to show results from the last 30 days.

 

Thanks in advance.

 

C

 

SELECT COUNT(a.id), a.productid, p.productid, p.producttitle, p.productcode, p.manfid, m.manfid, m.manufacturer, DATE_FORMAT(a.datetime, '%D %M %Y') as a.datetime
FROM tt_gear_afflinks_data a, tt_gear_product p, tt_gear_manufacturer m 
WHERE a.productid = p.productid AND p.manfid = m.manfid AND a.datetime = CURDATE() >= 30 
GROUP BY a.productid 
ORDER BY COUNT(a.id) DESC LIMIT 20

[JustLikeIcarus]

An example that gives you the last 30 days.

 

SELECT something FROM tbl_name
WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= date_col;