From: Nasreen Laghari on
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
From: Jason Pruim on
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(a)raoset.com



From: Nasreen Laghari on
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(a)raoset.com>
To: Nasreen Laghari <nasreen_laghari(a)yahoo.com>
Cc: php-db(a)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(a)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
From: Jason Pruim on
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(a)raoset.com>
> To: Nasreen Laghari <nasreen_laghari(a)yahoo.com>
> Cc: php-db(a)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(a)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(a)raoset.com



From: "STEVEN CRUZ" on
Hello;

What exactly do you mean? I have some jobs in cron that run a query and then
spit out an thml page via email. That type of thing?



>From: Nasreen Laghari <nasreen_laghari(a)yahoo.com>
>To: php-db(a)lists.php.net
>Subject: [PHP-DB] How to do a Newsletter
>Date: Thu, 1 May 2008 08:59:33 -0700 (PDT)
>
>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