Multiple emails being sent

[Drummin]

Can anyone spot where my error is or why I might be getting multiple emails sent?

$getNEWid2 = mysql_query("SELECT ID FROM ".$conf['tbl']['users']." ORDER BY ID DESC LIMIT 1 ");	
WHILE ($NEWid2 = mysql_fetch_array($getNEWid2)){
$send = mysql_query("SELECT name,user,email from ".$conf['tbl']['users']." WHERE ID=$NEWid2[iD]");
   WHILE($newsiteuser = mysql_fetch_array($send)) {
//emails sent here//
}}

 

[fugix]

you could try debugging your queries...

$getNEWid2 = mysql_query("SELECT ID FROM ".$conf['tbl']['users']." ORDER BY ID DESC LIMIT 1 ") or die(mysql_error());	
WHILE ($NEWid2 = mysql_fetch_array($getNEWid2)){
$send = mysql_query("SELECT name,user,email from ".$conf['tbl']['users']." WHERE ID=$NEWid2[iD]") or die(mysql_error());
   WHILE($newsiteuser = mysql_fetch_array($send)) {
//emails sent here//
}}

[Drummin]

Thanks Fugix for the reply.  I found the error higher in the code causing the POST to be run more than once.

[fugix]

okay glad you figured it out