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 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? 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. Link to comment https://forums.phpfreaks.com/topic/171404-order-by/#findComment-903995 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.