So I am trying to implement a points system on my site where the user opts in for points then I choose the number of points to give out. While this works fine with just 1 user, when there are multiple users it adds to the user on the bottom of the list and sets the other users points to that. The code controlling the points is
[php]$query = mysql_query(“SELECT points FROM users WHERE points_list=1”){
WHILE ($rows = mysql_fetch_array($query));
$points = $_POST[‘points’];
$oldpoints = $rows[‘points’];
$newpoints = $oldpoints + $points;
mysql_query(“UPDATE users SET points
=’$newpoints’ WHERE points_list
=‘1’”)or die(“Update not successful” . mysql_error());
}[/php]