Ok, I want to display the top 10 highest rated links in my database. In the database, each records has a field for total number of votes and the average of all of the votes. So link 1 may have a 5.00 rating with 1 vote and link 2 may have a 4.50 rating with 3000 votes. Is there a way I can sort of 'wieght' the links depending on the rating and number of votes? Im sorry of this sounds confusing, let me know if you need any claification.
it depends on how u write the order clause forexample if u want the query by rating first then vote u could write the query like this SELECT * FROM table ORDER BY rating, vote limit 0, 10 DESC
this query will sort the db by rating first then vote
