simple while loop

[netmastan]

Hi Guys,

I'm trying to send emails to the list of users an I got an template.

Here is my msg variable

$msg="Dear {name}, 

Your message goes here. 

{link}";

I want to loop through the user database and replace name and link

while($row=$db->fetch_array($result)){

$msg=str_replace("{name}",$row[user_name]);
$msg=str_replace("{link}","http://www.com/?code=$row[user_code]");

sendmail($row[user_email],$msg);

}

I'm getting the same user name and same link(code) for each email. My question is - foreach loop shouldn't $msg update ?

[NogDog]

Is that the exact code you're using? If so, you're missing the 3rd argument in each str_replace() call. But I'm guessing that's a copying error here, as I would expect a fatal error. So assuming that's not the problem, I think the real problem is that you are replacing the place-holders in $msg, then overwriting $msg with the result. Therefore after the first iteration, there will be no place-holders to be replaced for all successive loop iterations.

[netmastan]

That was logic.. youv'e understand the problem... I've just reviewed the code.. again ..silly me .. I couldn't fix this problem. All I had to do is put the $msg intial variable inside the loop.

while($row=$db->fetch_array($result)){
$msg=$_POST[msg];
$msg=str_replace("{name}",$row[user_name],$msg);
$msg=str_replace("{link}","http://www.com/?code=$row[user_code]",$msg);

sendmail($row[user_email],$msg);

}

Thanks for your help