Adding..

[Dobakat]

Well my users in my database have points, and here is a button to give points to a person, I was just woundering how could I do it.. Right know I have this..:

function procaddpoints()
{
global $session, $database, $form;
/ Username error checking /
$subuser = $this->checkUsername("user");
/ Errors exist, have user correct them /
if($form->num_errors > 0)
{
$SESSION['value_array'] = $POST;
$SESSION['error_array'] = $form->getErrorArray();
header("Location: ".$session->referrer);
}
else
{
$database->updateUserField($subuser, "points", points + (int)$POST['addpointsl']);
header("Location: ".$session->referrer);
}
}

This seems not to be adding the number I select to give to the amount of point the person had before, eventhough it takes me were I ask it to take me after adding those points .... I know my mistake probably is in:

$database->updateUserField($subuser, "points", points + (int)$_POST['addpointsl']);

could someone help me fix this so when I select 4 points it will add 4 to the previous amount of points it had.....

[Dobakat]

points is the name of the column were points are stored...

[bradgrafelman]

Well, I don't know how the updateUserField() function works, but here is an example SQL query you would run:

$query = "UPDATE `users` SET `points`= points+" . (int)($_POST['addpointsl']) . "WHERE ...";

etc.

[bretticus]

Is this the updateUserField method?

/**
    * updateUserField - Updates a field, specified by the field
    * parameter, in the user's row of the database.
    */
   function updateUserField($username, $field, $value){
      $q = "UPDATE ".TBL_USERS." SET ".$field." = '$value' WHERE username = '$username'";
      return mysql_query($q, $this->connection);
   }

if it is, unless 'points' in...

$database->updateUserField($subuser, "points", points + (int)$_POST['addpointsl']);

is a constant you have defined, you are effectively just making the value: $_POST['addpointsl'] (which I believe is what you said it was doing.)

USE bradgrafelman's example as the updateUserField method doesn't let you add the summation to the query. You can send that query to the $database->query() method, if it's the class I think it is:

/**
    * query - Performs the given query on the database and
    * returns the result, which may be false, true or a
    * resource identifier.
    */
   function query($query){
      return mysql_query($query, $this->connection);
   }