Mysql problem

[Linjon]

I need help with adding "points" to mysql. I have this code now:

mysql_query("UPDATE `wc3_player_race` SET `id`='".$_GET['message']."', `race` ='1', `race_xp`='".$AddPoints."' ");

But its only replaces points but i need it to add points. Hope you understand me

[jl5501]

mysql_query("UPDATE `wc3_player_race` SET `id`='".$_GET['message']."', `race` ='1', `race_xp`= `race_xp` + ".$AddPoints);

[Linjon]

Thanks, that worked!! But i have new problem now. If i add points then it give points only for first user on database and change him id to 0. How can i fix it?

<?php
  mysql_connect("localhost", "*******", "*****");
  mysql_select_db("*********");
  $result = mysql_query("SELECT `player_id` FROM `wc3_player` WHERE `player_name` ='".$_GET['message']."'");
  if(mysql_num_rows($result) == 0) {
  echo 'Cant find that name';
  }
  if(mysql_num_rows($result) > 0) {
  echo 'Points are added';
  $addxp = $row['race_xp'] = 75000; 
  mysql_query("UPDATE `wc3_race` SET `player_id`='".$_GET['message']."', `race_id` ='1', `race_xp`= `race_xp` + ".$addxp);
  }
?>