[Resolved] number 10 is showing as less than 9 when using DESC

[mband2000]

Hi, I have a rating script.. and on the homepage of my site.. it shows the members who are rated the highest.. with a certain number of votes. Here is the query code..

		$query = "SELECT * FROM ratings WHERE num_votes > 2 ORDER BY rating DESC LIMIT 10";
		$result = mysql_query($query);

It works perfectly until someone gets a perfect 10.00 rating... When that happens. the 10.00 is at the bottom of the list instead of the top.

Can someone point me in the right direction to solve this?

[mband2000]

ahhhhhh Nevermind.. I fixed it.

I made the mistake of making the 'rating' row.. VCHAR instead of INT..

I learn something new everyday with PHP & MYSQL..😃