Getting the recent one Week,month or year records from MySQL table
Weekly : select * from dt_table where `date` >= DATE_SUB(CURDATE(), INTERVAL 7 DAY) Monthly : select * from dt_table where `date` >= DATE_SUB(CURDATE(), INTERVAL 1 MONTH) Yearly : select *…