Mass Email

darylr

Hi all,

I am trying to set up a mass emailing system, but at the moment have had no luck.

Basically, I can create a form that can send an email to people (in the database) individually, but I would like to know how to send it to them all at once.

I (think) just have to get a code that will select the whole "email" column in the MySQL database, but do not know how to do this.

Can anybody help me? I am using Dreamweaver, and am still a noob :rolleyes:

Thanks in advance,

Daryl Reilly

rikmoncur

A nice chap called polvero has written an email suite which you can download for free
here

You can use it 'as is' or (as I did) learn from his code.

darylr

Hi - thanks for the reply.

After spending the past hour trying to work it out, still no luck 🙁

This is the code I have - can you please tell me where Im going wrong?

Firstly;

<?php
 mysql_select_db($database_conn_emx, $conn_emx);
$query_Recordset1 = "SELECT * FROM pilots";
$Recordset1 = mysql_query($query_Recordset1, $conn_emx) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>

Then, the email script;

<?php 


$to = $Recordset1['email'];
$subject = $sub;
$message = $msg;
$headers ='From: web@<my url>.com';

mail($to, $subject, $message, $headers);


?>

The $sub and $msg represent the form fields from the previous page.

Thanks again,

Daryl