Need help with adding to the database entry..

[muddy9494]

if($yourhp <= 0){ // defender won
	 $winner = $attack_person->id;
	 $yourhp = 0;
	 $battlewon = 1 + $attack_person->battlewon;
		 $moneywon = floor($user_class->money /10);
	 $battlemoney = $moneywon + $attack_person->battlemoney;
	 $expwon = 100 - (25 * ($attack_person-> level - $user_class->level));
	 $expwon = ($expwon < 0) ? 0 : $expwon;
	 $newexp = $expwon + $attack_person->exp;
	 $newmoney = $attack_person->money + $moneywon;
	 $result = mysql_query("UPDATE `grpgusers` SET `exp` = '".+$newexp."', `money` = '".+$newmoney."', `battlewon` = '".+$battlewon."', `battlemoney` = '".+$battlemoney."' WHERE `id`='".$attack_person->id."'");

	 $newmoney = $user_class->money - $moneywon;
	 $battlelost = $user_class->battlelost + 1;
	 $battlemoney = $user_class->battlemoney - $moneywon;
	 $result = mysql_query("UPDATE `grpgusers` SET `money` = '".$newmoney."', `hwho` = '".$attack_person->username."', `hhow` = 'attacked', `hwhen` = '".date(g.":".i.":".sa,time())."', `hospital` = '1200', `battlelost` = '".$battlelost."', `battlemoney` = '".$battlemoney."' WHERE `id`='".$user_class->id."'");
	 Send_Event($user_class->id, "You were hospitalized by ".$attack_person->username." for 20 minutes.");
	 echo Message($attack_person->formattedname . " Hospitalized you and stole $".$moneywon." from you.");

 

It is just saying how much xp they earned and it is not adding it to their current xp.

 

This is for a RPG script im making.

[Maq]

Because you need to tell it to:

 

SET `exp` = exp + $newexp, `money`

 

'exp' is an integer type, correct?

 

 

EDIT: Looking at it again, you have to change all of your updates to this format.

[muddy9494]

Yes, they all are int in the database.

[Maq]

Yes, they all are int in the database.

 

Then the above syntax should work, and should be applied to the rest of your MySQL operations.