Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[kingdkknox]

Im trying to reduce users stats and I need to exclude users that have 10 or less in a stat... how do I do that I tried

Code: [Select]

UPDATE `userstats` SET `strength`=((`strength`/100)*10) >10; but it didn't work mess the stats up everything went to 0.

[kingdkknox]

Figured it out
just had to add
WHERE strength >10

Code: [Select]

UPDATE `userstats` SET `strength`=((`strength`/100)*10) WHERE strength >10;

[Cronus]

Glad you figured it out, topic locked =)