UPDATE query question

[Anon]

I'm new to php and I'm trying to make a coin toss game that ads or minus's points from the users money...

$comp_guess = rand(1,2);
if($your_guess == $comp_guess) {
$Query = ("UPDATE $TableName SET money='money + 500' WHERE name='Ace'");
$Result = mysql_db_query ($DBName, $money, $Link);
echo "You Win!";
}
if($your_guess != $comp_guess) {
$Query = ("UPDATE $TableName SET money='money' - 500 WHERE name='Ace'");
$Result = mysql_db_query ($DBName, $Query, $Link);
echo "You Lost!";
}
?>

On the UPDATE $TableName, how do I make the user's money increase by 500? thx

[zhabala]

$Query = ("UPDATE $TableName SET money=money + 500 WHERE name='Ace'");

Is for increase by 500

$Query = ("UPDATE $TableName SET money=money - 500 WHERE name='Ace'");
is for decrease by 500

Zdenek

[Anon]

if(isset($tails, $heads)){
echo "<a href=coin.php>Please select an option</a>";
}
if(isset($heads)){
$your_guess = "1";
}
if(isset($tails)){
$your_guess = "2";
}
$comp_guess = rand(1,2);
if($your_guess == $comp_guess) {
$Query = ("UPDATE $TableName SET money=money + 500 WHERE name='Ace'");
$Result = mysql_db_query ($DBName, $Query, $Link);
echo "You Win!";
}
if($your_guess != $comp_guess) {
$Query = ("UPDATE $TableName SET money=money - 500 WHERE name='Ace'");
$Result = mysql_db_query ($DBName, $Query, $Link);
echo "You Lost!";
}
?>

thx for quick reply, it still won't add $500 to Ace's money....