[SOLVED] Add random number to database

[Zoroaster]

Hey guys thanks for taking the time to help me. I'm a bit stuck here... I'm trying to add a random number to a column in the database. Take a look at the part of the code I'm having trouble with:

 

if ($moneybutton)
{
mysql_query("UPDATE Login SET money = $money + (rand(2,10))
WHERE username LIKE '$username'");

}

 

When I click $moneybutton nothing in the database is changed. However, if I change "(rand(2,10))" to simply: "1" and then click $moneybutton, then the value changes to the previous value plus 1... I'd think it would be easy to just put in a simple rand function instead of the number itself, but apparently it wasn't.

 

Thanks for your time!

[tommyda]

You will need to set a variable with the new amount.

 

EG:

 

if ($moneybutton)

{

$newamount = $money + (rand(2,10));

mysql_query("UPDATE Login SET money = '$newamount'

WHERE username LIKE '$username'");

 

}

[Zoroaster]

Ahh... So simple! Hehe thanks mate, thanks a bunch.

[mikesta707]

If its an integer column (which it better be if you are doing math on it) then you cannot encase the value with single quotes

 

if ($moneybutton)
{
$newamount = $money + (rand(2,10));
mysql_query("UPDATE Login SET money = $newamount
WHERE username LIKE '$username'");

}