Edited news on top

Nuke Soldier Joined: Feb 06, 2005 Posts: 12

Hey, I want the edited news stories on my website to be displayed on top of the news list, if the news have been edited.

I have made up a way to do this in my mind, but i can't figure out how to do it in the codings.. My php skills are OK.

1. Alter the nuke_stories table by adding a column "edited". If a story has been edited either yes/1 or no/0 will be sat as a value in the field.

2. Sort the news by editen, then by id, but this is something i don't know how to do. I know its easy to sort by either eidted or id, but i don't know how to sort by one column, then sort by another.

Any ideas?

Site Admin Joined: Aug 17, 2003 Posts: 12342

I wonder if you can just update the date posted when you edit it, that would do what you want I think