<?php

include "db.php";

$query = "SELECT * FROM user_paypal_transactions WHERE payment_status = 'Completed' AND posting_time >= '2014-03-14 00:00:00' ORDER BY posting_time";
$results = db_query($query);

while ($row = db_fetch_assoc($results)) {
   extract($row);

   $trx = db_query("SELECT * FROM user_account WHERE school_num = $school_num AND transaction_type = 'Payment' AND payment_method = 'PayPal' AND payment_reference = '$txn_id'");
   $row = db_fetch_assoc($trx);
   $trx_fee = $row['transaction_fee'];
   $trx_num = $row['record_num'];

   if ($trx_num > 0 && floatval($mc_fee) != $trx_fee) {
      // echo("$txn_id - $mc_fee - $trx_fee - $posting_time\n");
      db_query("UPDATE user_account SET transaction_fee = $mc_fee WHERE record_num = $trx_num");
   }
}

?>