I have the following page:
<html>
<head>
<title>Sending message</title>
</head>
<body bgcolor="#000000" text="#FFFFFF" link="#CCCC00" vlink="#CCCC00" alink="#CCCC00" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="36">
<table width="100%" border="0" background="/bschedule/bsadmin/images/headerback.gif" cellspacing="0" cellpadding="0">
<tr>
<td height="60" width="6%"><img src="/bschedule/bsadmin/images/logosmall.gif" width="181" height="58"></td>
<td height="60" width="94%"><div align="center"><font face="Arial, Helvetica, sans-serif"><b><font color="#CCCC00">Band Mailer V: 1.0</font></b></font></div></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="2"><font color="#CCCC00" face="Arial, Helvetica, sans-serif">Sending The Email<br><font color="#000000">.</font></font></td>
</tr>
<tr>
<td height="2"><div align="center"><font face="Arial, Helvetica, sans-serif" size="2" color="#CCCCCC"><b><font color="#DFDFDF">Checking and sending your message</font></b></font></div></td>
</tr>
</table>[/HTML[code=php]]<?php
// set time limit to 15 minutes (900/60)
set_time_limit(900);
include('connect.php');
if(!isset($_POST['submit'])){
?>
<
form method="post" action="<?php print $_SERVER['PHP_SELF']; ?>">
<table align="center" bgcolor="#000000" border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td align="center" height="197">
<h2>Send Email<br>
<font face="Arial, Helvetica, sans-serif" size="2">Send message to:</font>
<select name="to" size="1" style="background-color: #F7F7F7">
<option selected value="all">Entire list
<option value="notall">By State
</select>
<font face="Arial, Helvetica, sans-serif" size="2">State:</font>
<select name="state" size="1">
<option value="Choosestate" selected>Choose State</option>
<option value="AL">AL</option>
<option value="AK">AK</option>
<option value="AZ">AZ</option>
<option value="AR">AR</option>
<option value="CA">CA</option>
<option value="CO">CO</option>
<option value="CT">CT</option>
<option value="DE">DE</option>
<option value="DC">DC</option>
<option value="FL">FL</option>
<option value="GA">GA</option>
<option value="GU">GU</option>
<option value="HI">HI</option>
<option value="ID">ID</option>
<option value="IL">IL</option>
<option value="IN">IN</option>
<option value="IA">IA</option>
<option value="KS">KS</option>
<option value="KY">KY</option>
<option value="LA">LA</option>
<option value="MD">MD</option>
<option value="ME">ME</option>
<option value="MA">MA</option>
<option value="MI">MI</option>
<option value="MN">MN</option>
<option value="MS">MS</option>
<option value="MO">MO</option>
<option value="MT">MT</option>
<option value="NE">NE</option>
<option value="NV">NV</option>
<option value="NH">NH</option>
<option value="NJ">NJ</option>
<option value="NM">NM</option>
<option value="NY">NY</option>
<option value="NC">NC</option>
<option value="ND">ND</option>
<option value="OH">OH</option>
<option value="OK">OK</option>
<option value="OR">OR</option>
<option value="PA">PA</option>
<option value="PR">PR</option>
<option value="RI">RI</option>
<option value="SC">SC</option>
<option value="SD">SD</option>
<option value="TN">TN</option>
<option value="TX">TX</option>
<option value="UT">UT</option>
<option value="VT">VT</option>
<option value="VA">VA</option>
<option value="VI">VI</option>
<option value="WA">WA</option>
<option value="WV">WV</option>
<option value="WI">WI</option>
<option value="WY">WY</option>
</select>
<font face="Arial, Helvetica, sans-serif" size="2"><br>
Your Name:
<input name="yourname" type=text maxlength=100 size=40>
Your Email:
<input name="yourname2" type=text maxlength=100 size=40>
<br>
Subject: </font>
<input name="subject" type=text maxlength=100 size=40>
<br>
<font size="2" face="Arial, Helvetica, sans-serif">Message: </font>
<textarea wrap name="message" rows=10 cols=45></textarea>
<br>
<input type=submit name="submit" value="Send">
<input type="reset" name="Submit2" value="Clear all">
</h2>
</td>
</tr>
</table>
</form>[/HTML[code=php]]<?php
}else{
$to = $_POST['to'];
$subject = $_POST['subject'];
$message = $_POST['message'];
$state = $_POST['state'];
if($to != 'notall'){
$x = 1;
$hold = 50;
// quantity of emails sent before 3 sec delay*/
$emails = mysql_query('SELECT email FROM users WHERE status = \''.$subscribed.'\'') or die(mysql_error());
while($sendemail = mysql_fetch_array($emails)){
$email = $sendemail['email'];
exit($email);
mail($emailAddress,$subject,$message,'From: '.$sender.' <'.$senderemail.'>') or die('It is the mail function that is bad ($emails)');
$x++;
if($x == $hold){
// When $x is equal to $hold, a 3 sec delay will occur avoiding php to timeout
sleep(3);
$x = 0;
}
}
// end of while loop
}else{
$bystate = mysql_query('SELECT email FROM users WHERE state = \''.$state.'\'') or die(mysql_error());
while($countmail = mysql_fetch_array($bystate)){
$email = $countmail['email'];
exit($email);
mail($emailAddress,$subject,$message,'From: '.$sender.' <'.$senderemail.'>') or die('It is the mail function that is bad ($bystate)');
$x++;
if($x == $hold){
// When $x is equal to $hold, a 3 sec delay will occur avoiding php to timeout
sleep(3);
$x = 0;
}
}
// end of while loop
}
print 'SUCCESS!';
}
?>[/PHP[code=html]]</body>
What I am wanting it to do is to send the mail to the people that are listed in the database that are marked as subscribed. I also want to choose the state or entire list from the menue.
Problem: I fill out the form and click send but it say's "Success" even though there isnt any emails being sent out. I am testing this on my own email address's so I wont clutter up innocent peoples mail boxes.
Anyone have an idea what I have wrong here?
I also am now thinking that I may not have something else set up correctly but dont know how to fix it. When the mail gets sent, I want to make sure the From and From email address's are what is filled out in the form.
Thanks in advance for any help.. it is GREATLY appreciated.
Peredy
To see the form in action, go to: http://www.jpaudiolabs.com/bschedule/bsadmin/sendletter.php
To see the names in list, go to: http://www.jpaudiolabs.com/bschedule/bsadmin/viewusers.php
Thanks again.
