Yes, I realize it's not 2016 yet, but this is just a learning experience for me; not real world application.
Code: Select all
// calculate total payments sent to affiliate for 2016
$query = "SELECT referral_fee_paid, referral_pay_date FROM payments WHERE affiliate = '".$company_name."' && referral_pay_date BETWEEN '01-01-2016' AND '12-31-2016' ";
$result = mysqli_query($con, $query) or die (mysqli_error($con));
$referral_paid_this_year = 0;
while ($row = mysqli_fetch_assoc ($result)) {
$referral_paid_this_year += $row['referral_fee_paid'];
}
// calculate total payments sent to affiliate for 2015
$query = "SELECT referral_fee_paid, referral_pay_date FROM payments WHERE affiliate = '".$company_name."' && referral_pay_date BETWEEN '01-01-2015' AND '12-31-2015' ";
$result = mysqli_query($con, $query) or die (mysqli_error($con));
$referral_paid_last_year = 0;
while ($row = mysqli_fetch_assoc ($result)) {
$referral_paid_last_year += $row['referral_fee_paid'];
}