2 messages in com.mysql.lists.mysqlRE: Plz help w/ php/MySQL
FromSent OnAttachments
Anthony Rodriguez05 Jan 2002 05:55 
Roger Baklund05 Jan 2002 07:48 
Subject:RE: Plz help w/ php/MySQL
From:Roger Baklund (roge@mobiliant.com)
Date:01/05/2002 07:48:27 AM
List:com.mysql.lists.mysql

* Anthony Rodriguez

The following php script successfully e-mails both messages but it doesn't update in the table "scr_149" the column "notified". Why?

Try moving this line:

$qry_2="update scr_149 set notified='y' where username='$username'";

...after this line:

$username=$row_1["username"];

And the same with $qry_4.