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@xxxxxxxxxx>
To: Nasreen Laghari <nasreen_laghari@xxxxxxxxx>
Cc: php-db@xxxxxxxxxxxxx
Sent: Thursday, May 1, 2008 5:03:43 PM
Subject: Re: 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@xxxxxxxxxx
--
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@xxxxxxxxxx
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
