karldesign Posted April 16, 2007 Share Posted April 16, 2007 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? Quote Link to comment https://forums.phpfreaks.com/topic/47260-solved-sql-order-problems/ Share on other sites More sharing options...
fenway Posted April 20, 2007 Share Posted April 20, 2007 My guess is that it's not a numerical field... change the column type, or try +0. Quote Link to comment https://forums.phpfreaks.com/topic/47260-solved-sql-order-problems/#findComment-233941 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.