The following php script successfully e-mails both messages but it doesn't
update in the table "scr_149" the column "notified". Why?
<?php
$connection=mysql_connect("localhost","wagner","123") or die ("No
connection!");
$db=mysql_select_db("sbwresearch_com",$connection) or die ("No database!");
$message_1="
Congratulations!\n\n
You've qualified to take the online survey # 149.\n\n
To take the survey, go to www.sbwresearch.com and click on Survey / Tests.\n\n
";
$message_2="
Sorry!\n\n
You've not qualified to take the online survey # 149.\n\n
We'll notify you by e-mail of upcoming screeners.
";
$qry_1="select * from scr_149 where q05a!=\"0\" && notified=\"n\"";
$qry_2="update scr_149 set notified='y' where username='$username'";
$result_1=mysql_query($qry_1,$connection) or die ("No query # 1!");
while ($row_1=mysql_fetch_array($result_1, MYSQL_ASSOC))
{
$username=$row_1["username"];
$e_mail=$row_1["e_mail"];
mail("$e_mail",
"News from SBW Research",
"$message_1",
"From:SBW Research <[EMAIL PROTECTED]>\n");
$result_2=mysql_query($qry_2,$connection) or die ("No query # 2!");
};
mysql_free_result($result_1);
$qry_3="select * from scr_149 where q05a=\"0\" && notified=\"n\"";
$qry_4="update scr_149 set notified=\"y\" where username='$username'";
$result_3=mysql_query($qry_3,$connection) or die ("No query # 3!");
while ($row_2=mysql_fetch_array($result_3, MYSQL_ASSOC))
{
$username=$row_2["username"];
$e_mail=$row_2["e_mail"];
mail("$e_mail",
"News from SBW Research",
"$message_2",
"From:SBW Research <[EMAIL PROTECTED]>\n");
$result_4=mysql_query($qry_4,$connection) or die ("No query # 4!");
};
@mysql_free_result($result_3);
@mysql_close($connection);
header ("location:done.htm");
exit;
?>
Thanks!
Anthony F. Rodriguez
([EMAIL PROTECTED])
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
