[SOLVED] mySQL ORDER BY not working

[Maximus]

Hi, I am trying to retrieve 10 entries with the highest value in field "votes".

 

$result = mysql_query("SELECT * FROM `sites` ORDER BY `votes` ASC LIMIT 0,10");

while($g = mysql_fetch_array($result))
{
echo '<br>'.$g['name'].' - '.$g['votes'].' Votes</a>';
}

 

The code above displays ten entries, but doesn't but them in order from high to low.  I don't understand...

 

The output looks like this:

 

dsgdsg - 0 Votes

dgds - 0 Votes

omg lol - 0 Votes

gkjkfgs - 0 Votes

fhfd - 0 Votes

lhhgllk - 0 Votes

dfhjdfj - 2434 Votes

test - 5 Votes

gjdfd - 5765 Votes

fjdgdd- 64 Votes

 

Ignore the phony names, but rather focus on the order of the "votes"...its really weird.

[AndyB]

My bet is that the field votes is a text (or varchar) field instead of a numeric field.

[Maximus]

You're right, it is a varchar field.  I changed it (in table structure) to "INT" and now it works perfectly.  Thanks so much!