Plz help w/ php/MySQL
| From: | Anthony Rodriguez | Date: | Sat, 05 Jan 2002 13:50:37 +0000 |
| Subject: | Plz help w/ php/MySQL | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-79560@lists.php.net to get a copy of this message | ||
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 <mail@sbwresearch.com>\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 <mail@sbwresearch.com>\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
(afrodriguez@att.net)