Mutley Posted April 11, 2007 Share Posted April 11, 2007 In my database I have a field with numbers, when I arrange them DESC, it says 5819 is greater than 500355. Why is this? My numbers show in this order: 903669 5819 500355 319 -50002 I tried clearing them and re-entering the numbers but no luck. Link to comment https://forums.phpfreaks.com/topic/46626-sql-and-numbers/ Share on other sites More sharing options...
craygo Posted April 11, 2007 Share Posted April 11, 2007 Your field type is probably set to varchar set it to int and you will be fine Ray Link to comment https://forums.phpfreaks.com/topic/46626-sql-and-numbers/#findComment-227027 Share on other sites More sharing options...
paul2463 Posted April 11, 2007 Share Posted April 11, 2007 is the field of type integer or type varchar??? Link to comment https://forums.phpfreaks.com/topic/46626-sql-and-numbers/#findComment-227028 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.