Re: How to do a Newsletter

Without seeing any of your code to base it off of I'd select it like this: $sql = "SELECT email, emailNewsletter FROM mytable where emailNewsletter='YES'"; then just loop through the array that gets returned... while ($row = mysqli_fetch_assoc($result)) { //build the e-mail } Obviously, there's more to it, but that should get you started. If you run into trouble, post code that we could look at and see if we can help you. On May 1, 2008, at 12:17 PM, Nasreen Laghari wrote:

I have to email it. Basically I have run a query according to user criteria of newsletter and send it via email ----- Original Message ---- From: Jason Pruim <japruim@raoset.com> To: Nasreen Laghari <nasreen_laghari@yahoo.com> Cc: php-db@lists.php.net Sent: Thursday, May 1, 2008 5:03:43 PM Subject: Re: [PHP-DB] How to do a Newsletter That's not an awful lot to go off of.. I'm assuming the actual newsletter is already produced probably in a PDF? Are you looking to e-mail it out? Post it to a website? Get e-mail addresses to e-mail it to? Get postal addresses to postal mail it to? More info I think would definitely help. On May 1, 2008, at 11:59 AM, Nasreen Laghari wrote:

Hi, Does any one know a better way of doing "Newsletter". I have to run a query and send that data to clients. Regards ____________________________________________________________________________________ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ

-- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 3251 132nd ave Holland, MI, 49424-9337 www.raoset.com japruim@raoset.com --PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

     ____________________________________________________________________________________

Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ

-- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 3251 132nd ave Holland, MI, 49424-9337 www.raoset.com japruim@raoset.com