project3 Posted March 19, 2008 Share Posted March 19, 2008 Im having a problem i need to sort by numbers. when displaying the numbers got 1,10,11,12,13,14,15,16,17,18,19,2,20 instead of 1,2,3,4,5,6,7,8,9 how can I fix this. Link to comment https://forums.phpfreaks.com/topic/97001-php-mysql-sort-order/ Share on other sites More sharing options...
cooldude832 Posted March 19, 2008 Share Posted March 19, 2008 technical if those are "strings" that is the proper sorting of them you need to convert to integers first then sort or Order By a integer type field off a query Link to comment https://forums.phpfreaks.com/topic/97001-php-mysql-sort-order/#findComment-496384 Share on other sites More sharing options...
project3 Posted March 19, 2008 Author Share Posted March 19, 2008 technical if those are "strings" that is the proper sorting of them you need to convert to integers first then sort or Order By a integer type field off a query perfect. i switched that field to a integer and its all better. Link to comment https://forums.phpfreaks.com/topic/97001-php-mysql-sort-order/#findComment-496388 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.