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