if you follow your code you see that you do 0 - 1000 and it's logic to be
-1000.
Jennifer Downey a écrit :
> Hi all,
>
> I'm still banging my head on this.
>
> Let's say I have $1000 to withdraw from my account. I withdraw that $1000
> which leaves me $0 dollars in the account.
> With the code below if I enter another $1000 dollars in the form and hit
> enter it loans me the thousand and puts my account at -$1000 dollars.
> What do I need to do to stop it from loaning me the thousand and keep me
> from having a negative balance?
>
> <TABLE BORDER="0" WIDTH="25%" CELLPADDING="0" CELLSPACING="0">
> <TR>
> <TD><font size="2">Withdraw</font></TD>
> <TD> <INPUT TYPE="text" VALUE="" NAME="user_withdraw"></TD>
> </TR>
> <TR>
> <TD></TD>
> <TD><INPUT TYPE="submit" VALUE="Make My Withdrawal" NAME="withdraw"></TD>
> </TR>
> </TABLE>
> </FORM>
>
> // used to update if a user makes a withdrawal
> $query = ("UPDATE wt_users set bank_points = bank_points - $user_withdraw,
> points = points + $user_withdraw WHERE uid={$session["uid"]}");
> $result=mysql_query("$query");
>
> // select bank points for the user.
> $sql_result = mysql_query("SELECT bank_points FROM wt_users WHERE
> uid={$session["uid"]}");
> $row = mysql_fetch_array($sql_result);
> // if bank points are at 0 then print no points and quit.
> if ($sql_result <= "0") {
> echo "you don't have that many points";
> exit;
> } else {
> echo "Your withdraw has been made!";
>
> Thanks again in advance
>
> Jennifer Downey
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
--
Marius Ursache (3563 || 3494)
\|/ ____ \|/
"@'/ ,. \`@"
/_| \__/ |_\
\__U_/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
