bford21 Posted March 24, 2011 Share Posted March 24, 2011 Hey guys so I'm working on creating my own CMS for my website and one of the features I am having trouble with is creating the script to mail a newsletter to everyone in the database. I thought it would be simple enough but I cant seem to figure it out. When I run the code below everything seems to work however only the first email in the database actually receives an email. I think it might be something with my while() loop but I'm not sure. Any help would be greatly appreciated. $subject = $_POST['subject']; $message = nl2br($_POST['message']); // To send HTML mail, the Content-type header must be set $headers = 'MIME-Version: 1.0' . "\r\n"; $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n"; // Additional headers $headers .= 'From: B.net' . "\r\n"; // Connect to database // requires Global Functions ratings_db_connect(); // Finds the number of verified subscriptions $qry ="SELECT * FROM subscriptions WHERE verified ='yes'"; $result = mysql_query($qry); while ($email = mysql_fetch_array($result)){ $email = $email['email']; mail ($email,$subject,$message,$headers); } Quote Link to comment Share on other sites More sharing options...
bford21 Posted March 25, 2011 Author Share Posted March 25, 2011 Anyone have any solutions for me. I still haven't been able to figure it out. I have however been reading up on different ways to do this and was wondering if a while loop was the way to go. Thanks Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.