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. Link to comment https://forums.phpfreaks.com/topic/110436-archive-question/ 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? Link to comment https://forums.phpfreaks.com/topic/110436-archive-question/#findComment-566608 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. Link to comment https://forums.phpfreaks.com/topic/110436-archive-question/#findComment-566613 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. Link to comment https://forums.phpfreaks.com/topic/110436-archive-question/#findComment-566625 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.