Re: excluding same field values in mysql

i am selecting company because the company i am writing this for wanted me to print out on a web page all the company names that had gotten mail from the email system.. and i didnt know if i should do a different query for that or if i could leave it in 1 query... so could i do this: select company, distinct email from members; wasnt sure if that would work right or not... or would i need to do something else for the company print out tnx ----- Original Message ----- From: JanetVal@aol.com To: rusty_81@msn.com Sent: Wednesday, February 19, 2003 8:41 PM Subject: Re: [PHP] excluding same field values in mysql In a message dated 2/19/2003 5:22:19 PM Pacific Standard Time, rusty_81@msn.com writes: 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] "; } echo "go back to main menu"; ?> 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? I don't know why you are selecting company, but it you didn't, you could use the following query. select DISTINCT Email from members That would eliminate duplicate email addresses. Janet --- 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