The Little Guy Posted August 12, 2008 Share Posted August 12, 2008 I need an update code that will take the column "points" and take 15% of the score off. So if the score is: 1000 when the update runs, the users new score will be: 850 Anyone know how I could do this? Link to comment https://forums.phpfreaks.com/topic/119247-solved-modify-a-score-remove-15/ Share on other sites More sharing options...
toplay Posted August 12, 2008 Share Posted August 12, 2008 update table_name set column_name = column_name * 0.85 where .... Link to comment https://forums.phpfreaks.com/topic/119247-solved-modify-a-score-remove-15/#findComment-614229 Share on other sites More sharing options...
The Little Guy Posted August 12, 2008 Author Share Posted August 12, 2008 I actually got this, and it works: ((`points`) - (`points` * 0.15)) Link to comment https://forums.phpfreaks.com/topic/119247-solved-modify-a-score-remove-15/#findComment-614250 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.