adipalmer123 Posted March 14, 2012 Share Posted March 14, 2012 Hi all I've created a database with news articles. And a page that displays the newsarticles through dynamic links. What I want to do though is start archiving past posts into months. I want say on the February link just display the posts between 1 - 29th feb. My query currently displays all posts in the database $news_sql="SELECT newsID, headline, dateposted, image, article FROM news ORDER BY newsID DESC"; Can anyone help with modifying this to display posts between dates? Thanks in advance Link to comment https://forums.phpfreaks.com/topic/258893-displaying-records-between-specific-dates/ Share on other sites More sharing options...
AyKay47 Posted March 14, 2012 Share Posted March 14, 2012 Since you haven't really provided everything that I need to answer this accurately, I will assume that the `dateposted` field is type DATE. SELECT newsID, headline, dateposted, image, article FROM news WHERE dateposted BETWEEN '2012-02-01' AND '2012-02-29' ORDER BY newsID DESC Link to comment https://forums.phpfreaks.com/topic/258893-displaying-records-between-specific-dates/#findComment-1327221 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.