violinrocker Posted August 22, 2009 Share Posted August 22, 2009 how do i order fields with mixed letters and numbers? i tried using ABC('title') but it shows... title 1 title 10 title 110 title 2 title 21 title B 1 title B 10 and so on... its like 1,10,11,12.. then 2,20,21,22... what I want is 1,2,3,4,5 Quote Link to comment https://forums.phpfreaks.com/topic/171404-order-by/ Share on other sites More sharing options...
Daniel0 Posted August 22, 2009 Share Posted August 22, 2009 Any reason why you don't store them as separate fields? Quote Link to comment https://forums.phpfreaks.com/topic/171404-order-by/#findComment-903941 Share on other sites More sharing options...
fenway Posted August 22, 2009 Share Posted August 22, 2009 Agreed... but if there's a fixed format, you can fudge it. Quote Link to comment https://forums.phpfreaks.com/topic/171404-order-by/#findComment-903995 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.