Wierd Math

[Napster]

I have this code in part of my game. This code is used for, if they trip they will lose hit points and money. But for some reason it doesn't work that way

$pain243 = rand(1,2);
$lost234 = rand(1,5);

$row667 = mysql_query("SELECT * FROM members WHERE username='$username'") or die(mysql_error());
$campaign667 = mysql_fetch_array($row667);

$hurt599 = $campaign667[hp] - $pain243;
$money599 = $campaign667[money] - $lost234;

mysql_query("UPDATE members SET money='$money599' WHERE username='$username'");
mysql_query("UPDATE members SET money='$hurt599' WHERE username='$username'");

For example, if it says i lose 1 hit point, i will gain 1 hit point etc I dont know what is wrong. Please help if you can

[Weedpacket]

Um, you want to set their money to how much they were hurt by?

You can turn those three queries into one and not have to do the bit in between either:

"update members set money=money-$lost234, hp=hp-$pain243 where username='$username'"

And what's with the weird variable names?

[Napster]

lol, again I am an idiot, thanx