I am trying to update a value into a mysql column called price (decimal 10,2).
So i start of with the price at say 150.00 then I try to update after a calucation that returns say 154.5 which wouldnt update.
So i formated the number to look like 154.50 and the field still won't update. Im getting no errors back, has anyone have any idea?
Yes ive printed all values, its definetly getting the right record, its just not changing the column for some reason..?
So i start of with the price at say 150.00 then I try to update after a calucation that returns say 154.5 which wouldnt update.
So i formated the number to look like 154.50 and the field still won't update. Im getting no errors back, has anyone have any idea?
Yes ive printed all values, its definetly getting the right record, its just not changing the column for some reason..?