[PHP] email newsletter with MySQL - help please!

2001-08-13 Thread Herman Pijpers
Being a rather new to php I find myself completely stuck on a script which is possibly a piece of cake for most of you: I want to set up a weekly ezine. Both email addresses and news articles will be retrieved from two separate MySQL tables called subscribers and newsarticles. I put together

Re: [PHP] email newsletter with MySQL - help please!

2001-08-13 Thread Richard Baskett
Try something like: ?php $listquery = SELECT emailaddress FROM subscribers; $listresult = mysql_query($listquery); $newsquery = SELECT * FROM newsarticles; $newsresult = mysql_query($newsquery); while($listrow = mysql_fetch_array($listresult)) { $newsrow = mysql_fetch_array($newsresult))