Thursday 26 February 2015

get last 30 days data in php

select * from `tablename` where `yourdatefield` >= 
 DATE_SUB(CURDATE(), INTERVAL 30 DAY)

No comments:

Post a Comment