Update SET table ?? weired Problem

[hirashah]

i am trying to do this

      $q = "  UPDATE user_settings SET  maxval='$val' WHERE id='$USERID'   " ;
       if (  $db->query($q) ) die("Done");
        else { die("Error"); }

Now here comes the problem
If value already stored in SQL table for maxval is 10
and i try to update it with again 10 it returns die("Error");
however if i change values for maxval then it returns success

is there a way to overcome this , that this should update table no mater what value is inside before ???

Waiting ? Thankx

[liquorvicar]

i'm not sure of the structure of your DB class but have you tried checking the return value against FALSE (===FALSE) rather than zero. it seems like somewhere your query is executing and returning 0 affected rows. remember (0 == FALSE) returns TRUE but (0 === FALSE) returns FALSE.