e1seix Posted January 31, 2008 Share Posted January 31, 2008 Hi there, Was just wondering what way to get around this problem. Am using the code $qry = mysql_query("SELECT * FROM fragrances WHERE fragrances.avail='true' UNION SELECT * FROM skincare WHERE skincare.avail='true' ORDER BY perc DESC LIMIT $startrow1, $limit1")or die(mysql_error()); to list some items on my website. the perc represents a saving in cost, so naturally i want to show the highest saving, or bargain, products up front. however as php does is that it sees, it will list 9.50% before 94.0%. it doesn't take into account the decimal point. is there a way around this? cheers Link to comment https://forums.phpfreaks.com/topic/88652-solved-order-by-decimal-number/ Share on other sites More sharing options...
kenrbnsn Posted January 31, 2008 Share Posted January 31, 2008 What is the datatype of the perc field? Ken Link to comment https://forums.phpfreaks.com/topic/88652-solved-order-by-decimal-number/#findComment-453983 Share on other sites More sharing options...
e1seix Posted January 31, 2008 Author Share Posted January 31, 2008 VARCHAR. that's it, isn't it? change it to DECIMAL right? Link to comment https://forums.phpfreaks.com/topic/88652-solved-order-by-decimal-number/#findComment-453984 Share on other sites More sharing options...
kenrbnsn Posted January 31, 2008 Share Posted January 31, 2008 Yes, change it to something numeric. Link to comment https://forums.phpfreaks.com/topic/88652-solved-order-by-decimal-number/#findComment-453992 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.