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