Hi Robert, Please take a look at php manual and try to know something about $_POST, $_GET etc. Your code is full of errors. On Sun, 6 Mar 2005 15:33:30 -0500, Robert <sigler@xxxxxxx> wrote: > Hi - > > I am very new to php and can't get this to work right. It keeps telling me > there is no send header. I have tried multiple variations? Any ideas? I > am simply trying to query the database and send out an email to each person > in my database. > > Thanks, > Robert > > $query = "SELECT first_name, email FROM offer"; > $result = @mysql_query ($query); > > if ($result) { > echo 'Mailing List...'; > while ($row = mysql_fetch_array ($result, MYSQL_NUM)) { mysql_fetch_row can be an alternative. > $fname = "$row[0]"; > $body = "<html><body>Hi {$_POST['fname']},</body></html>"; You are sendting the email to users who are in the database, but greeting them with $_POST['fname'] > $headers = "MIME-Version: 1.0\r\n"; > $headers .= "Content-type: text/html; charset=iso-8859-1\r\n"; > $headers .= "From: "; >From is not set, value is not here. > $sendto = "$row[1]"; > echo "<br>Row one output = $sendto<br>"; > mail ($_POST['sendto'],'Testing', $body, $headers); Again you are sending the mail to same person very time. > echo "Sent to $row[1]<br>";} Again problem. > mysql_free_result ($result); > > -- PHP manual is good thing to start . http://www.php.net zareef ahmed -- Zareef Ahmed :: A PHP Developer in India ( Delhi ) Homepage :: http://www.zareef.net -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php