[APuppyDog]

Hi, i would like to change my users points. Some of them have points that are like 11.. i would like any points that are less than 50 to be 50 PLUS the amount they have...

so something like this

SELECT * FROM `phpbb_users` WHERE 'user_points' less than 50, user_points = user_points + 50

is this possible?

[infinitylimit]

Yeah you have good pseudocode.

www.w3cschools.com and read up on the sql.

[APuppyDog]

Originally Posted by infinitylimit

read up on the sql.

thanks, but thats of no help, i tried reading the UPDATE query but it doesn't apply since i don't know how to do less than or equal to..

[kasper]

http://www.w3schools.com/php/php_operators.asp

the page IL gave you has all the operators and conditionals of php and what you need to complete your update.

the less than equal to operator on that page is <=

[APuppyDog]

thanks, this is what i used.

UPDATE phpbb_users SET user_points=user_points+50 WHERE user_points <= 50;

worked like a charm