Problem in Code?

I can't seem to figure out where I am going wrong .... it could be everywhere although any help would be great thank you in advance.

$statsmain = mysql_query("SELECT * FROM statsmain WHERE statsuid='$uid'");
while($row = mysql_fetch_array($statsmain))

$cash = $row['cash'];
$depositamt = $_POST["depositamt"];
$bank = $row['bank'];

if("$depositamt" <= "$cash")
{
$cashremaining = "$cash" - "$depositamt";

$depminus10p = "$depositamt" *.9;
$banknewamt = "$depminus10p" + "$bank";

mysql_query("UPDATE statsmain SET cash = $cashremaining WHERE statsuid = $uid");

mysql_query("UPDATE statsmain SET bank = $banknewamt WHERE statsuid = $uid");

Code (markup):

 

$statsmain = mysql_query("SELECT * FROM statsmain WHERE statsuid='$uid'");
while($row = mysql_fetch_array($statsmain)) {
$cash = $row['cash'];
$depositamt = $_POST["depositamt"];
$bank = $row['bank'];

if($depositamt <= $cash) {
$cashremaining = $cash - $depositamt;

$depminus10p = $depositamt*.9;
$banknewamt = $depminus10p + $bank;

mysql_query("UPDATE statsmain SET cash = $cashremaining WHERE statsuid = $uid");

mysql_query("UPDATE statsmain SET bank = $banknewamt WHERE statsuid = $uid");
} //end if
} //end while

Code (markup):

That could the code you want. You should post more detailed algorithm of your program!

 

the while(), you did not put a curly bracket after it. { }

 

This should work. Like ads2help said, you forgot the curly brackets for your while statement. You also put a beginning bracket for your if statement, but no closing one.

<?php
$statsmain = mysql_query("SELECT * FROM statsmain WHERE statsuid='$uid'");

while($row = mysql_fetch_array($statsmain))
	{
$cash = $row['cash'];
$depositamt = $_POST["depositamt"];
$bank = $row['bank'];

	if("$depositamt" <= "$cash")
		{
		$cashremaining = "$cash" - "$depositamt";
		$depminus10p = "$depositamt" *.9;
		$banknewamt = "$depminus10p" + "$bank";

		mysql_query("UPDATE statsmain SET cash = $cashremaining WHERE statsuid = $uid");
		mysql_query("UPDATE statsmain SET bank = $banknewamt WHERE statsuid = $uid");
		}
	}
?>

PHP:

 

and all these were wrong

        $cashremaining = "$cash" - "$depositamt";
        $depminus10p = "$depositamt" *.9;
        $banknewamt = "$depminus10p" + "$bank";

PHP:

just follow the chmdznr's