PHP Newsletter Script

[bford21]

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);
			}

 

[bford21]

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