mysql - PHP: view unsuccessful emails -
mysql - PHP: view unsuccessful emails -
i'm trying figure out how display list of unsuccessful emails sent , way test out. can display list of emails sent, i'm unsure on how retrieve list of emails unsuccessfully sent out.
here i'm using retrieve mysqldb:
//get email address list $query = "select email users id in (select participant_id roster ur ur.roster_id=".$roster['roster_id'].")"; $result = mysql_query($query); $emailstring2 = ""; $email2 = $result; while ($row = mysql_fetch_object($email2)){ $emailstring2 .= $row->email. "\n "; }
in message section, retrieve via:
$message .="successful emails: \n".$emailstring2." \r\n";
how accomplish this?
one keyword ones not sent: not
where id not in
mysql php
Comments
Post a Comment