PHP - Moved: Updating A Php Variable?

Hello Everyone,

I am pretty new to the forums and was curious if i could get some help here. Basically, in a nutshell, i have PayPal integrated into my website. I will use this to collect money from clients. when a client logs into his/her account they see their balance (which is pulled from the database to correspond with the user that's logged-in). Now, everytime a payment is submitted a notify_url is contacted after payment has been verified, that notify_url is the code written below. What I am trying to execute here is when this notify_url is called the current balance is reduced from the amount paid through paypal.

In the second If condition, you will see that the word success is being entered into the paypal.txt file, which is working perfectly fine. Now, you will also see the variable


$update_balance;  


which is suppose to update the original balance with the balance paid through PayPal

BUT IT'S NOT!! WHY?? LOL

Thank You in advance!


<?php
ob_start();

session_start();

include_once ('/home/rdewebde/public_html/includes/paypal.php');

$myPaypal = new Paypal();

$myPaypal->ipnLog = TRUE;
        
include_once "/home/rdewebde/public_html/includes/_config.php";

$username = "".$_SESSION['username']."";

$users_data = mysql_query("SELECT * FROM `members` WHERE `username`='".$username."'");

$user_info = mysql_fetch_array($users_data);

$current_amount = $user_info['balance'];
     
$deduct_amount = $myPaypal->ipnData['payment_gross'];

$new_amount = $current_amount - $deduct_amount;

$update_balance = mysql_query("UPDATE `members` SET `balance` = '$new_amount' WHERE `username` = '".$username."'");

if ($myPaypal->validateIpn()) {

    if ($myPaypal->ipnData['payment_status'] == 'Completed') {

         $update_balance;  

         file_put_contents('/home/rdewebde/public_html/lounge/paypal.txt', 'SUCCESS');

            

    }

else { file_put_contents('/home/rdewebde/public_html/lounge/paypal.txt', "FAILURE\n\n" . $myPaypal->ipnData); }

   }

?> 

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=334445.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=351353.0

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=314136.0

This topic has been moved to PHP Regex.

http://www.phpfreaks.com/forums/index.php?topic=312460.0