dachshund Posted December 13, 2011 Share Posted December 13, 2011 hi, i have a column in a list of products called 'price'. it's a varchar column. each price is in this format 8.00 or 12.00 always with 2 decimals. when i try and sort by price it only goes by the first number, so something that's 1.00 will be next to something that's 100.00. if i make the column INT then it works, but then i can't have a decimal. anyone know how to fix this? thanks, jack Quote Link to comment https://forums.phpfreaks.com/topic/253103-problems-sorting-by-price/ Share on other sites More sharing options...
Pikachu2000 Posted December 13, 2011 Share Posted December 13, 2011 Make it a decimal data type. Quote Link to comment https://forums.phpfreaks.com/topic/253103-problems-sorting-by-price/#findComment-1297554 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.