[Resolved] [Resolved] email results of an array?

[gunhoe86]

im trying to set a cronjob to email me a list of the emails in a db each week. here's my code:

require_once ("config.inc");
$query = "select email from emails";
$result = mysql_query($query);

mail("[e-mail]","email list","while (
$rows = mysql_fetch_assoc($result))
{
echo(\"$rows[email] \n\");
}","From: [email][e-mail][/email]")
or die("error");

echo("should have worked");

im receiving the email, but the body of the email is:

while (
$rows = mysql_fetch_assoc($result))
{
echo(\"$rows[email] \n\");
}

anyone have any ideas on how to do this?

~JOSH

[mmilano]

that's because your php logic is inside quotes. i'm not sure if it would work that way even if you took the quotes out.

make life a little easier for yourself, and your code easier to read by taking the loop out of the mail function.

try this:

<?
require_once ("config.inc");
$query = "select email from emails";
$result = mysql_query($query);

while($row = mysql_fetch_row($result))
{
  $text .= $row[email] . "\n";
}

mail("[e-mail]","email list",$text,"From: [email][e-mail][/email]")

echo("should have worked");
?>

[gunhoe86]

hhhmmmm i think i'd tried that before, and i tried it again and it sends me a blank email

thanks for the help though

~JOSH

[gunhoe86]

nevermind i fixed it.

i was calling up $row[email] from mysql_fetch_row.

i switched it to mysql_fetch_assoc and it works fine now, thanks to mmilano.

~JOSH