Re: [PHP-DB] How to do a Newsletter
[email protected] (Jason Pruim)
| Newsgroups | php.db |
|---|---|
| Message-ID | <[email protected]> |
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 <[email protected]>
> To: Nasreen Laghari <[email protected]>
> Cc: [email protected]
> 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
> [email protected]
>
>
>
>
> --
> 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
[email protected]