PHP Mailer if else

Question

我正在尝试在注册确认后发送不同的电子邮件给用户。一个将为管理员用户和其他文本将为基本用户。我写了和if else语句基于查询的数据，但它发送两个电子邮件给两种类型的用户。你知道哪里出问题了吗？

function SendBusWelcomeEmail(&$user_rec)
    {
 $result = mysql_query("SELECT business FROM users")
               or die(mysql_error());


if($result='a') {
        $mailer = new PHPMailer();

        $mailer->CharSet = 'utf-8';

        $mailer->AddAddress($user_rec['email'],$user_rec['name']);

        $mailer->Subject = "Welcome to ".$this->sitename;

        $mailer->From = $this->GetFromAddress();        

        $mailer->Body ="Thank You ".$user_rec['name']." for joining xxx, \r\n\r\n".
        "We are a brand new business with big ambitions. Our mission is to help the development of your skills \r\n".

        "\r\n".
        "Regards,\r\n".
        "Webmaster\r\n".
        $this->sitename;
}
        if(!$mailer->Send())
        {
            $this->HandleError("Failed sending user welcome email.");
            return false;
        }
        else{
        $mailer = new PHPMailer();

        $mailer->CharSet = 'utf-8';

        $mailer->AddAddress($user_rec['email'],$user_rec['name']);

        $mailer->Subject = "Welcome to ".$this->sitename;

        $mailer->From = $this->GetFromAddress();        

        $mailer->Body ="Hello ".$user_rec['name']."\r\n\r\n".
        "Welcome! Your registration  with ".$this->sitename." is completed.\r\n".
        "\r\n".
        "Regards,\r\n".
        "Webmaster\r\n".
        $this->sitename;

        if(!$mailer->Send())
        {
            $this->HandleError("Failed sending user welcome email.");
            return false;
        }
}
    }

Answer 1

在您的条件下，它应该是==而不是=。

所以改变吧

if($result = 'a')

至

if($result == 'a')

注意：：您没有获取记录。而且您的查询似乎必须包含where条件才能获取用户的业务类型。不过，我不确定。

提示：为什么不从这两个条件中获取通用代码&只需根据条件更改邮件正文内容。

Answer 2

在这行之后

$result = mysql_query("SELECT business FROM users") or die(mysql_error());

用于获取结果。

$result = mysql_fetch_array($result);