Help w/ ORDER BY

[edt]

Hi All!

I have a top songs of the year voting script. When a user votes on a song, it adds +1 to the current song count. For example,

artist song votes
U2 Song Title 12

The problem is, when I do my SELECT statement to get the songs, in order of most votes down, it doesnt show them correctly. Here is my SELECT statement:
select * from $songtable order by votes DESC
This is what I get:

Red Hot Chili Peppers - Tell Me Baby [6 Votes]
Deftones - Hole In The Earth [4 Votes]
Thom Yorke - Black Swan [3 Votes]
Red Hot Chili Peppers - Dani California [2 Votes]
AFI - Miss Murder [16 Votes]
The Strokes - Heart In A Cage [1 Votes]
Red Jumpsuite Apparatus - Face Down [1 Votes]

The problem is that AFI - Miss Murder [16 Votes] doesnt get up at the top.
Any idea how to get around this?

Thanks in advance!!

Edt

[rincewind456]

It looks like you have your vote field not set as an integer, that is the sort of result I would expect if you where doing an ORDER BY on a string field.

[edt]

ahhh.
easy fix. thank you so much!