MiCR0 Posted July 19, 2010 Share Posted July 19, 2010 I am trying to work out a Discount system maths logic for an MYSQL statment, and I can not get my head into Gear so any help would be great. I am working on a system where the user inputs 20% or -20% and then it querys 35,000 products and updates them with the new price now becuase the records are so big I have a problem so its a one statment job. (cost * 0.20) adds on 20% Update products SET cost = (cost* 0.20) WHERE bradletter='A'; // adds 20% to the price I think the above is correct how would you remove 20%? thanks MiCR0 Link to comment https://forums.phpfreaks.com/topic/208200-this-is-doing-my-head-in/ Share on other sites More sharing options...
Daniel0 Posted July 19, 2010 Share Posted July 19, 2010 Add 1%: new = original * (1 + 0.01) = original * 1.01 Subtract 1%: new = original * (1 - 0.01) = original * 0.99 Link to comment https://forums.phpfreaks.com/topic/208200-this-is-doing-my-head-in/#findComment-1088262 Share on other sites More sharing options...
MiCR0 Posted July 20, 2010 Author Share Posted July 20, 2010 Your a Star Daniel Thank you. Link to comment https://forums.phpfreaks.com/topic/208200-this-is-doing-my-head-in/#findComment-1088498 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.