Today
This Week
This month select * from news where news_category_id=2 and show_status='y' and delete_status='n' and `news_created_date` BETWEEN DATE_SUB( CURDATE( ) ,INTERVAL 30 DAY ) AND CURDATE( ) order by news_created_date
This month
