I have made this code for giving out +1 point, but it doesn't work properly.
mysql_query(" UPDATE member_profile SET points= ' ".$points." ' + 1 WHERE user_id = '".$userid."' ");
the $points variable is the user´s points right now.. I want it to plus one to it.. so example if he had like 5 points, it should be 5+1 = 6.. but it doesnt, it just changes to 1
What have i done wrong? thank you
You could also just do this:
mysql_query(" UPDATE member_profile SET points = points + 1 WHERE user_id = '".$userid."' ");
You can do this without having to query the actual amount of points, so it will save you some time and resources during the script execution.
mysql_query("UPDATE `member_profile` SET `points`= `points` + 1 WHERE `user_id` = '".intval($userid)."'");
Else, what you were doing wrong is that you passed the old amount of points as a string (
points='5'+1), and you can't add a number to a string. ;)