Re: Duplicate e-mails

Hi Anthony: Anthony Rodriguez wrote: > > The following php script sends two (2) e-mails to each addressee. Why? I'll bet the email addresses in question are listed in the table twice. Open up a MySQL command line prompt and enter "select * from con_inf;" to make sure. To keep this from happening, you can delete the duplicates then add a unique index on the "e_mail" field in the MySQL table definition. > $qry_1="select * from con_inf"; Side Issue 1: why are you selecting everything (via "*") rather than just "e_mail", since that's all you're using in the script? > $result_1=mysql_query($qry_1,$connection) or die ("No query # 1!"); > > while ($row_1=mysql_fetch_array($result_1, MYSQL_ASSOC)) > > { > $e_mail=$row_1["e_mail"]; > mail("$e_mail", Side Note 2: You can combiune those two lines into one: mail($row_1['e_mail'], > mysql_free_result($result_1); > mysql_close($connection); Side Note 3: You don't worry about these commands in scripts you're about to exit anyway. Enjoy, --Dan -- PHP scripts that make your job easier http://www.analysisandsolutions.com/code/ SQL Solution | Layout Solution | Form Solution T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y 4015 7 Ave, Brooklyn NY 11232 v: 718-854-0335 f: 718-854-0409