StanLytle Posted September 4, 2007 Share Posted September 4, 2007 I need some help with sorting. If the field attribute is INT, and the data is 1, 2, 3, 10, 20, 30, they sort as: 1 2 3 10 20 30 But if the field attribute is VARCHAR, and the data is ABC 1, ABC 2, ABC 3, ABC 10, ABC 20, ABC 30, they sort as: ABC 1 ABC 10 ABC 2 ABC 20 ABC 3 ABC 30 How can I get alpha/numeric data, seperated by a space, to sort like INT? Thanks, Stan Link to comment https://forums.phpfreaks.com/topic/67927-help-with-sorting/ Share on other sites More sharing options...
Jessica Posted September 4, 2007 Share Posted September 4, 2007 http://us.php.net/natsort Link to comment https://forums.phpfreaks.com/topic/67927-help-with-sorting/#findComment-341413 Share on other sites More sharing options...
Barand Posted September 4, 2007 Share Posted September 4, 2007 see http://www.phpfreaks.com/forums/index.php/topic,156889.0.html Link to comment https://forums.phpfreaks.com/topic/67927-help-with-sorting/#findComment-341416 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.