Duplicated e-mail addresses

[Anon]

I currently use this script below to raid a databas and send an e-mail to every e-mail address:

<?

if (($subject =="") || ($newsletter == "")) {

    header("Location: http://www.spursweb.com/sendmail.phtml");
    exit;

} else {

    // connect to db
    $db = mysql_connect("localhost", "spursweb", "iversen")
            or die ("Couldn't connect.");

    mysql_select_db("spursdb", $db) or die ("Couldn't select db.");

    $sql = "select senderemail from sos";

    $res = mysql_query($sql) or die("Couldn't get addresses.");

    $headers = "From: \"Save Our Spurs Mailing-List\" <[e-mail]>\n";


    while ($row = mysql_fetch_array($res)) {

            $email_addr = $row[0];

            mail("$email_addr", "$subject", $newsletter, $headers);

    }

    echo "newsletter sent!";

}

?>

How would I set it up so that, if the same address got into the database twice, that person wouldn't receive two e-mails. So, in essence, the script would e-mail all unique addresses.

[Anon]

"select DISTINCT senderemail from sos"

[Anon]

Use the DISTINCT in your SQL statement as follows:

$sql = "select DISTINCT senderemail from sos";

This will ensure that it only returns each email address once.