Mass mail to database records

[jstratos]

I have a simple php script that allows people to register their names to a database containing two fields (Name & email).

I can then login to the database, from the front-end, and view all the records in the database table. I can also click on the email address for each record and email them as I have <a href mailto:> assigned to that email display field.

There is also a <delete> option if I wanted to delete that record.

 

Question:

How can I code this so I can choose to email everyone if I wish to?

 

Here's my display code which is set to repeat until all names are displayed in the list:

 

<?php do { ?>

                    <tr>

                      <td nowrap="nowrap" class="style1"><?php echo $row_nw_signup['name']; ?></td>

                      <td class="style1"><a href="mailto:<?php echo $row_nw_signup['email']; ?>" class="style3"><?php echo $row_nw_signup['email']; ?></a></td>

                      <td><a href="confirmDelete.php?recordID=<?php echo $row_nw_signup['name']; ?>" class="style3">Delete</a></td>

                  </tr>

                    <?php } while ($row_nw_signup = mysql_fetch_assoc($nw_signup)); ?>

[ratcateme]

you want to look into using the php mail() function or this pear package that is more suited to mass mailing

http://pear.php.net/package/Mail

 

Scott.