for loop in mail()

[webmasternovis]

Hi all,

Could someone tell me how I could put a for loop in mail()?

I'm trying this at the moment, but I just get an unexpected T_FOR error.

mail("[e-mail]", "Weekly Update", 
for ($x=0; $x < mysql_num_rows($new); $x++)
	{
		echo $row[field];
		}
		,"from:site");

Could anyone give me a hand?

Thanks,
Mike

[Frederick]

You don't place a loop in the mail(), you place the mail() in the loop.

while( $row = mysql_fetch_array($sql)) {
    mail("email","subject","message","From: ");
}

[webmasternovis]

That seems to send one email for every database entry. I'm looking to send every entry in a database in one email. Does anyone know how to do this?

Thanks a lot,
Mike 🙂

[Erestar]

Well, you don't do the for loop in the call to mail(). What you'd do is run a for loop before the call, going through your database, and appending each row to a variable. Then you pass that variable to mail() as the body parameter, a al:

$body = "";
for ($x=0; $x < mysql_num_rows($new); $x++)
    {
        //this line won't actually work... You'll need to do something like mysql_fetch_array() or whatever
        $body .= $row[field];
     }

mail("[e-mail]", "Weekly Update", $body);

[webmasternovis]

Ya, kinda works now, thanks 🙂