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