php error with games bank

[Renlok]

ive tryed to make a bank where users can withdraw and deposit there money within the game but i cant get the transactions to work, no idea what could be wrong they just dont work.

[code] //userdata
  $username = $HTTP_COOKIE_VARS['mysite_username'];
  $query = "SELECT * FROM users WHERE md5='$username'";
  $result = mysql_query($query);
  $row = mysql_fetch_array($result);

$trans = $_POST['trans'];
$amount = $_POST['amount'];
$mult = $_POST['mult'];

//getting username
$username = $row['username'];

//amount stored in bank for current user
$bank = $row['bank'];

//amount of points user has on hand
$points = $row['points'];

//getting bank rate
$rate = $row['bankrate'];
$ratequery = "SELECT * FROM bankrates WHERE id='$rate'";
$raterun = mysql_query($ratequery);
$raterow = mysql_fetch_array($raterun);
$intrate = $raterow['value'];

//getting interest values
$dayrate = (($bank/100)*$intrate);
$yearrate = $dayrate*365;

if($trans == 'trans')
{
if($bank < $amount) {
echo "Thats not possible";
unset($_POST['trans']);
}

$amount = $amount*$mult;
$newbank = $bank+$amount;
$newpoints = $points-$amount;

//updating users
$banksql = "UPDATE users SET points='$newpoints' AND bank='$newbank' WHERE username='$username'";
$runtrans = mysql_query($banksql) or die("Error<br>".mysql_error());
echo "Processing";
unset($_POST['trans']);
}[/code]

[Philip]

if($trans == 'trans')

Wouldn't the $trans be a number?

[tcollie]

Maybe this line....

[code]$runtrans = mysql_query($banksql) or die("Error<br>".mysql_error());[/code]

I could be wrong.

[corbin]

Try changing if($trans == 'trans') to if($trans)