I have a Mysql table where I store prices of a product. I have the values in "varchar" format because I needed to include "decimals" in the prices(for eg. 15.30) and "int" doesn't allow that.
Having done that, when ever I filter the products by prices in Ascending or Descending order, they don't show up in proper order. It seems like the decimal in the prices is messing up the order.
Is there a way to fix this so that the php query can filter the prices in proper order despite the decimals?
Here's the eg of the query.
$get_records = $db->prepare("SELECT * FROM records ORDER BY records.price DESC");