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 Quote Link to comment 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.