Opt-In-Mailing List

[fire_cracker]

I'm going to change my handle to the pest I think. I'm just full of problems this week :lol:

I'm trying to set up the program to e-mail everyone in my opt in mailing list. I have a table set up in my database to hold all the e-mail addresses, and I'm trying to make a simple form to send the mails. There seems to be some problem in the script; however, because the form will sumit, act like it is working, but the e-mails are not being sent. here is the code I'm passing the information to. it is being done through PHP_SELF.

<?
if($sumbit)
{
mysql_connect(localhost,$user,$pass) or die("Could Not Connect to the Database");
mysql_select_db($db) or die("Could Not Connect to the database");
$count = 0;
$result = mysql_query("SELECT * FROM mailinglist ORDER BY id DESC") or die("Could Not Query the Database");
while ($row = mysql_fetch_array($result)) {
$recipient = $row['email'];
$additional_headers = "FROM: [email][e-mail][/email]";
mail($recipient,$subject,$message,$additional_headers) or die("Could Not Send the Mail");
$count++;
}
echo "<center>Message sent to $count user(s)</center>");
}

[kevinsequeira]

how many users approximately are there in your database. try changing
mail($recipient, $subject, $message, $additional_headers) or die("Could Not Send the Mail");

to if(mail($recipient, $subject, $message, $additional_headers)){
echo "mail sent to ".$recipient."<BR>";
}else{
echo "mail not sent to ".$recipient."<BR>";
}

see the output
reg
kevin

[fire_cracker]

So far, I have about 500-600 people that will be added to the new table I'm creating. I'll go ahead and give that a try, to see if it works or not.

[fire_cracker]

Okay, I just gave that a try, and it didn't give me any output. I have no idea what the problem could be. I'm not getting any errors from MySql or from PHP, it looks like the page is just reloading itself with a blank form. Here is the full code to the page:

<?
if($sumbit)
{
mysql_connect(localhost,$user,$pass) or die("Could Not Connect to the Database");
mysql_select_db(dbforum) or die("Could Not Connect to the database");
$count = 0;
$result = mysql_query("SELECT * FROM mailinglist ORDER BY id DESC") or die("Could Not Query the Database");
while ($row = mysql_fetch_array($result)) {
$recipient = $row['email'];
$additional_headers = "FROM: [email][e-mail][/email]";
if(mail($recipient,$subject,$message,$additional_headers))
{echo "Mail sent to ".$recipient;}
else
{echo "Mail not sent to ".$recipient;}
$count++;
}
print("<center>Message sent to $count user(s)</center>");
}
else
{
include('header.html');
?>
<br>
<br>
<br>
<form method="post" action="<? PHP_SELF ?>">
<table border="0" width="100%">
<tr>
<td align="center" valign="center" style="background:gray">
<h3>Mailing List Mailer</h3>
<table border="0" width="100%">
<tr>
<td align="left" valign="top"><B>SUBJECT:</B></td>
<td align="right" valign="top"><input type="text" name="subject" size="30" style="background:#CCCCCC;border:none"></td>
</tr>
<tr>
<td align="left" valign="top"><b>MESSAGE:</b></td>
<td align="right" valign="top"><textarea cols="60" rows="10" name="message" style="background:#CCCCCC;border:none"></textarea></td>
</tr>
</td>
</table>
<center><input type="submit" name="submit" value="submit"></center>
</td>
</tr>
</table>
</form>
</td>
</tr>
</table>
</body>
</html>
<?
}
?>

It is probably one of those errors that are so easy to overlook, especialy for a noob like me 🙂

Thanks for the help