excluding same field values in mysql
| From: | Sunfire | Date: | Thu, 20 Feb 2003 01:22:30 +0000 |
| Subject: | excluding same field values in mysql | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-136288@lists.php.net to get a copy of this message | ||
hi
im making a mailing system for a company. i have to find all email addresses
in a table and send email to all of them. the problem comes in when more
than 1 company has the same email address (owned by same person). what i
have to do is if more than 1 company has the same email address only use one
of them that are the same for the email not all of them..
example:
company1 email: company1@whatever.com
company2 email: company1@whatever.com
in the example above i want to only use one of those addresses since they
would end up getting 2 emails and that wouldnt look right..
code i have so far is:
<?php
//connect to db stuff here
$query=mysql_query("select company, Email from members");
while($mail=mysql_fetch_array($query)){
mail($mail[Email], $subject, $message, "from: $sender");
echo "mail was sent to: $mail[company]<br>";
}
echo "<a href=\"main.php\">go back to main menu</a>";
?>
works fine except only using an email address 1 time if more than one of the
same email..
anybody have any ideas how to fix this?
tnx
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.443 / Virus Database: 248 - Release Date: 1/10/2003