Version: 1

Type: Sample Code (HOWTO)

Category: Databases

License: GNU General Public License

Description: an easy way to update a row in a while loop.



<?
$email_query="select * from email";
$email_result=mysql_query($email_query);

if ($send == 2) {
print("<p>Email being cleared");
while ($email=mysql_fetch_row($email_result)) {

if ($email[1] == 'y') { 
 $email_mysql_query = ("UPDATE email SET sent='n' WHERE id = $email[3]"); 
 $email_mysql_query_result = mysql_query($email_mysql_query); 
 print ("<p>email cleaned"); 
}

}
}
?>