Changing order of posts in news module

Worker Joined: May 26, 2006 Posts: 153

Is it possible to change the order of the news items displayed in the news module. I need to be able to move posts about in the module so that they are displayed in order of "date occurring" rather than when they have been entered onto the site. Something similar to the block display admin module would be very useful.

registered · Posted: Sat Jan 16, 2010 9:02 am

You could try to change the SELECT statement that is within the function theindex() from:

Code:




ORDER BY s.sid DESC

to

Code:




ORDER BY s.time DESC

Just be sure to take a backup of your script first or test the change on a local copy.

Posted: Sun Jan 17, 2010 10:00 am

Hi Montego, probably wasn't very clear in the original post.
I don't want to change the order of the displayed posts as such. What has happened is that I have posted some news stories in the site and then discovered that I have missed some posts out.
When I then put them onto the site they get the latest post ID number and are normally displayed first (at the top) in the news module.
I need an easier way to re arrange the order in which the posts are displayed, regardless of the post ID number.
For instance be able to move them up or down the list, in a similar way to how we can move the order of displayed blocks in the block admin module. Hope this is clearer.

Posted: Tue Jan 19, 2010 8:28 pm

You can do exactly that by virtue of the change I suggested above. Change the news article posting date/time and it is descending order by date/time.