[RESOLVED] help with mail form

[jshooper]

Hi. I'm trying to use a newsletter script and am having a problem with the send letter file. This script works from a mysql database and all other functions work correctly. The problem is that I get a Notice: Undefined index: email in /usr/home/websites/visit/admin/sendletter.php on line 25. Line 25 is this line: $email = $r['email'];. I cannot for the life of me figure out the problem. Can anyone here see a possible cause?
Here is the sendletter.php:

<?php
error_reporting(E_ALL);
// set time limit to 15 minutes (900/60)
set_time_limit(900);
include("connect.php");
	$id = preg_replace("/'\/<>\"/","",$_GET['id']);
	if (empty($id))
	die("Invalid ID");
	$link = "SELECT * FROM newsletters WHERE id='$id'";
	$res = mysql_query($link) or die(mysql_error());
	$r = mysql_fetch_assoc($res);
	$subject = $r['name'];
	$message = $r['content'];

$headers  = 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
$headers .= 'From: newsletter@' . $_SERVER['SERVER_NAME'] . "\r\n" .
'Reply-To: newsletter@' . $_SERVER['SERVER_NAME'] . "\r\n" .
'X-Mailer: PHP/' . phpversion();

$link = "SELECT * FROM users WHERE status='subscribed'";
$res = mysql_query($link) or die(mysql_error());
while ($r = mysql_fetch_row($res))
{
	$email = $r['email'];
	$mail = mail($email, $subject, $message, $headers);
}

if ($mail)
{
echo "Email sent to " . $email . '<br>';
die;
}
else
{
echo "Error in mailing " . $email . '<br>';
die;
} 

?>

Thanks!

[Horizon88]

That's not an error, per se, it's a notice - your script will keep running. It's just telling you that on line 25, you're referencing a key in an array that is not present - $r['email'] is not being set for some reason or another. Could you post contact.php? Or do a print_r($r); to see the structure of your array?

[jshooper]

Thank you for the reply. Actually the script doesn't work. It looks like it stops at that point and never sends out the email. Like it doesn't query any email addresses. This is the message after doing print_r($r);

Notice: Undefined index: email in /usr/home/websites/visit/admin/sendletter.php on line 25
Array ( [0] => My Name [1] => MyEmailAddress [2] => 2007-12-03 09:52:26 [3] => subscribed [4] => 0 [5] => 1 ) Email sent to

[Horizon88]

That's because you'll see in your array, $r['email'] doesn't exist. You have $r[0] - $r[5], but you aren't setting 'email' anywhere in your script. I'd assume you're trying to set the SQL fields directly into $r, but it looks like either there isn't an sql field named email, or you aren't pull it from the database.

[jshooper]

Yes! I see now. Thank you so much!

[Gatura]

So how exactly did you solve the problem of pulling the email information from the database. I am not very adapted to php.