MySQL Order By Issue

[Zepo.]

I have a loop thats ordered by the field proiority. It works fine untill the priority gets above 9.

http://www.eliteladders.com/development/ladders.php

As you can see it put it after 1.

$groups=mysql_query("SELECT id,name,logo,active,priority,created FROM groups WHERE active='1' ORDER BY priority");
while(list($gid,$gname,$glogo,$gactive,$gpriority,$gcreated)=mysql_fetch_row($groups)){

[trq]

What field type is priority?

[Zepo.]

varchar

Limit 4

[trq]

There your problem. A varchar field will be ordered alphabetically. it will need to be an INT type.

[Zepo.]

Thank you very much sir.

[sasa]

try ORDER BY priority+0