I have a rating system on a forum I'm building. Users can rate a topic either good or bad. For each Good rating, one point is added to the topic's score. For every Bad rating, one point is subtracted to the topic's score.
Each time a rating is made, several things are inputted into a MySQL table called ratings
rating_id
rating_date
rating_username
rating_topic
rating_value
What I want to be able to do is query this table to grab the highest rated topics and lowest rated topics in a given time period. My MySQL knowledge is pretty limited right now, so any help would be much appreciated.
Thanks.
Each time a rating is made, several things are inputted into a MySQL table called ratings
rating_id
rating_date
rating_username
rating_topic
rating_value
What I want to be able to do is query this table to grab the highest rated topics and lowest rated topics in a given time period. My MySQL knowledge is pretty limited right now, so any help would be much appreciated.
Thanks.