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 Quote 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 Quote 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 Quote Link to comment https://forums.phpfreaks.com/topic/67927-help-with-sorting/#findComment-341416 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.