// Get emails form each sku and call the sendEmail function.
function prepareEmail($sku)
{
    $errors = 0;
    $query2 = "SELECT p_sku, p_name, p_users, p_review_link FROM product_list WHERE p_sku = '".$sku."'";
    $result = mysql_query($query2);
    while($thing = mysql_fetch_assoc($result))
    {
        // Returns a list of customer IDs e.g. 123,124,125,126,127,128
        foreach(explode(',',$thing['p_users']) as $key=>$value)
        {
            // gets customer email with id.
            $userArray = getUserDetails($value);

            if($userArray != false)
            {
                //$fname = $userArray[0];
                //$lname = $userArray[1];
                $email = $userArray[2];
                //$u_id = $userArray[3];

                $name_address = $email

                // Action
                if(!sendEmail($name_address, $sku, $thing['p_review_link'],$value))
                {
                    $errors++;
                    $emails[] = $name_address;
                }
            }
        }
    }

    // If success, mark as list sent
    if($errors == 0)
    {
        setSent($sku);
        if(count($emails) > 0)
        {
            blacklist($emails);
        }
        //header('Location:index.php');
        return getList();
    }
    // if fail, blacklist failed email addresses, display errors and mark as sent.
    else
    {
        setSent($sku);
        var_dump($emails);
        blacklist($emails);
        die('Emails Failed to send on "sendEmail()"');
    }
}

// Get customer details array for prepareEmail function
function getUserDetails($id)
{
    if($id != null)
    {
        $query2 = "SELECT u_fname, u_lname, u_email, u_id FROM user_list WHERE u_id = '$id' AND u_blacklisted != 1 AND u_delete != 1";
        if($result = mysql_query($query2))
        {
            return mysql_fetch_row($result);
        }
        else
        {
            return false;
        }
    }
    else
    {
        return false;
    }
}

function sendEmail($email,$sku,$review_link,$u_id)
{
    // Generate email template
    $template = getTemplate($sku,$review_link,$emails,$u_id);

    // Create a mailer class with your Amazon ID/Secret in the constructor
    $mailer = new AmazonSESMailer('XXXXXXXXXX', 'XXXXXXXXXXXXXXXXXXXXXXXX');

    // Then use this object like you would use PHPMailer normally!
    $mailer->AddAddress($email);
    $mailer->SetFrom('[email protected]');
    $mailer->Subject = 'subject';
    $mailer->MsgHtml($template[1]);

    // Send! Returns true or false(With error)
    return $mailer->Send();
}