PHP Code:

$upbalance = mysql_query("SELECT accountbalance FROM probid_users WHERE id='".$_POST['auctionid']."'");
                                    if ($maxbid<=$upbalance) {
                                    $nbalance = $upbalance - $maxbid;
                                    $insertnewbalance = mysql_query("UPDATE probid_users SET accountbalance='$nbalance' WHERE id='".$_SESSION['memberid']."'");
                                    } 


For some reason I don't know my database won't update the "accountbalance"

and yes $maxbid is defined and that's fine along with .$_POST['auctionid'].

PHP Code:

$insertnewbalance = mysql_query("UPDATE probid_users SET accountbalance='$nbalance' WHERE id='".$_SESSION['memberid']."'"); 


This is really the line that's causing problems...

Thanks in advance for your help

Hi Moforce, I'm not 100% sure about this but it would appear that you left out a required commas;

$insertnewbalance = mysql_query("UPDATE probid_users, SET accountbalance='$nbalance', WHERE id='".$_SESSION['memberid']."'");

Hope that helps.

Please read the manual and tell me what does mysql_query() return. Then tell me what is the value of $upbalance after calling mysql_query() in your case. After that you probably should resolve your problem.

Your $upbalance variable is merely a resource and cannot be used in a conditional statement. You need to use a mysql_fetch function to return an array and then use this array to extract the id value.

PHP Code:


$upbalance = mysql_query("SELECT accountbalance FROM probid_users WHERE id='".$_POST['auctionid']."'");
$row = mysql_fetch_assoc($upbalance);  
                              

if ($maxbid<=$row['id']){  // rest of conditional 


</span></span>

I fixed a part of the code..

PHP Code:

$upbalance = getSqlField("SELECT accountbalance FROM probid_users WHERE id='".$_SESSION['memberid']."'","accountbalance");
        if ($maxbid<=$upbalance) {
        $nbalance = $upbalance - $maxbid; 


So now all of that is fine... but how can I update the database to replace the accountbalance to $nbalance?

PHP Code:

$insertnewbalance = mysql_query("UPDATE probid_users SET accountbalance='$nbalance' WHERE id='".$_SESSION['memberid']."'"); 


That needs to be changed because the database isn't updating

Thanks for helping me out guys... I managed to figure it out..

PHP Code:

<? ## SUBTRACT BID FROM BALANCE!!!
        $upbalance = getSqlField("SELECT accountbalance FROM probid_users WHERE id='".$_SESSION['memberid']."'","accountbalance");
        if ($maxbid<=$upbalance) {
        $nbalance = $upbalance - $maxbid;
        
        mysql_query("UPDATE probid_users SET accountbalance='$nbalance' WHERE id='".$_SESSION['memberid']."'");
        
                                    } ?>

That's the working code in case any of you guys wondered