I am working on a php/mysql driven website where users can make posts.
Other users can vote up/down on these posts.
I am working on an Algorithm to order these posts.
I want the posts with the highest NET points to be displayed on top, however I also want to give priority to new posts.
This is what I have so far,
ORDER BY points_up - points_down DESC, timestamp DESC
However I want to do something along these lines.
(points_up - points_down) / minutes
The minutes being the number of minutes the post has been active. However I’m not sure how to implement the minutes feature using my timestamp.