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 Quote 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 Quote 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? Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.