MySql will not sort values correctly?

[champbronc2]

OK I have a table, and I want to sort it by who has the most visits.

 

I do this:

 

Select * From users Where referer = '' ORDER BY visits DESC;

 

So I'd have someone with 9 visits and another person with 86 visits.

 

But it lists 9 before 86...

 

It seems to be sorting by the first digit from the left, when I need to to sort by the greatest number..

 

And like it'd list 9 before 65 or 54 and so on.

 

How can I fix this?

[waynew]

Select * From users Where referer = '' ORDER BY visits DESC;

 

Where referer = ???? Are sure that this isn't the problem?

 

Why is their only one double-quotes?

[PFMaBiSmAd]

Your column is not an integer data type. Change it to an integer data type.

[champbronc2]

How can I change the column to an interger data type? I am new sorry

[dropfaith]

do you have php my admin?

 

 

if so use it and just change the  type to int  i assume its varchar or something now..

[champbronc2]

Thank you!