Solarpitch Posted June 16, 2008 Share Posted June 16, 2008 Hey, I have a list of articles that are being called from a database and display in order of upload date onto the page. I would like to archive articles that are older than two months into a separate page. So initially I would select all he archives that are less than two months and display on page1, then do a second one to select all the remaining ones that are older than two months and display on page 2. Just looking for a bit of help to get started if I can.. cheers. Quote Link to comment Share on other sites More sharing options...
webent Posted June 16, 2008 Share Posted June 16, 2008 Sounds like all you need to do then is just put two different queries on those two different pages... Do you have an example of your query? Quote Link to comment Share on other sites More sharing options...
Solarpitch Posted June 16, 2008 Author Share Posted June 16, 2008 I dont... I was just trying to come up with what way to implement it. So could I have a query to SELECT * FROM articles Where upload_date.... then something here about less than 2 months. Not sure how id do that tho. Would that be the best way yeah. Quote Link to comment Share on other sites More sharing options...
revraz Posted June 16, 2008 Share Posted June 16, 2008 Show your current query you use now. All you have to do is use a date value to display by. Also state what date format you use. 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.