mail function problem

[Anon]

hi,

I have problem about the mail function. When I using the mail function out of the while loop, it can work. But when I using it under a while loop function, although it can sending the email, but the subject, sender cannot see anything. Why?

Machi

[kparker]

You need to show the actual code you are using.

[Anon]

<?php

//The following is work
mail("[e-mail]","title","message","From: [e-mail]");

//rountine for connecting to the mysql
...
...

//The following cannot work??

while ($row = mysql_fetch_row($result)) {

list($email,$title,$message) = $row;

mail($email,$title,$message,"From: [e-mail]");

};
?>

[kparker]

Sure, it might work. To see what is happening, echo the contents as you're producing the emails:

&nbsp;&nbsp;while ( list($email,$title,$message) = mysql_fetch_row($result))
&nbsp;&nbsp;&nbsp;&nbsp;{
&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;echo "&lt;br&gt;To: $email&lt;br&gt;";
&nbsp;&nbsp;&nbsp;&nbsp;echo "Subject: $title&lt;br&gt;";
&nbsp;&nbsp;&nbsp;&nbsp;echo "Body: $message&lt;br&gt;&lt;br&gt;";
&nbsp;&nbsp;&nbsp;&nbsp;mail($email,$title,$message,"From: [e-mail]");
&nbsp;&nbsp;&nbsp;&nbsp;}

[kparker]

Just in the interest of clean coding, note that $row is not needed; you might as well just directly assign the results of the fetch to the list() of variables.