I'm running into a problem with a ratings script I'm writing. The
overview is that a user can rate an item from 1-10. What I want it to do
is display the highest rated item, with 10 being the highest rating. In
case there are multiple items sharing the same score, the item that has
been rated the most should be displayed.
Here's a bit of the code:
$albums=mysql_query("SELECT albumRating,totalRatings WHERE
albumType='Album' ORDER BY albumRating,totalRatings DESC");
The problem I'm running into is that it always displays the item with a
9 rating and not the 10. I'm figuring it's because mysql is seeing the
order as 9,8,7,6,5,4,3,2,10,1
Am I going to have to store the numbers as 01,02,03,etc... in order to
get this to work right or is there a better way to structure the query?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
