is the quantity field in the database set to int or float ? int requires whole numbers, whereas float allows decimals of varying precision