[SOLVED] SQL ORDER problems

[karldesign]

I have the following statement:

 

$query = mysql_query("SELECT * FROM tbl_categories WHERE int_id = 2 ORDER BY int_position ASC");

 

This statement runs fine, except, unlike statements I have used before (almost identical, just different table), the ORDER BY sorts them as follows:

 

1, 10, 11, 12, 2, 3, 4, 5, 6, 7, 8, 9 etc...

 

When what I actually want is:

 

1, 2, 3, 4, 5, 6, 7 etc...

 

Anybody know why this is doing this now but not on previous queries?

[fenway]

My guess is that it's not a numerical field... change the column type, or try +0.