Phpmailer uses to send letters to many people, but there is a problem with the title.

$mail->Subject = " ".$row["name"]."";
        $mail->Body = "xxx";
        $mail->AddBCC($row["email"]);

I want to send more than one person using a while circle
now there is a problem
is sure to send it to more than one person, all will receive
but the name of the person is the same?
I have to print it out first to see if there are different names and different emails. Make sure it is different! The
title will always be a person"s name. I guess $mail- > Subject cannot be repeated.
so can we make $mail- > Subject and $mail- > Body multiple displays to different users?
can have more than one

like $mail- > AddBCC .
Apr.16,2021

Update the answer, read the code, and find that the send method is outside the while loop. Please move the send method to the body of the while loop.
at the same time, each time before the while loop, add the sentence $mail- > ClearAllRecipients () before the recipient is removed.

'.$host_url.'products/'.$url.'</a>';
        $mail->AddBCC($row['email']);
        
        if(!$mail->Send()) {
            echo 'error';
        }
      }
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b3b2a3-2babb.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b3b2a3-2babb.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?