Codice PHP:
$m_sql = "select * from tabella where id = " .$id ;
$result = mysql_db_query( $nome_db, $m_sql, $db) or die(mysql_error());
while ($row = mysql_fetch_array($result))
{
//qui fai l' UPDATE APPROVATO
$sql = " UPDATE tabella set approvato = 'Y' where id= ".$row["id"]."";
$result = mysql_db_query( $nome_db, $sql, $db) or die(mysql_error());
$email = "".$row["email"]."";
$responsabile = "".$row["responsabile"]."";
//etc......
}
$to = $email;
$cc = "tuo@indirizzo.email";
$subject = "Approvazione etc....";
$message = "Gentile\n\r";
$message .= "[b]$responsabile[/b]
\r\n";
$message .= "con la presente e-mail la informiamo che:\r\n";
$message .= " sei stato approvato!!!!
\r\n";
$from = "tuo@indirizzo.mail";
$headers = "MIME-Version: 1.0\r\n";
$headers .= "Content-type: text/html; charset=iso-8859-1\r\n";
$headers .= "Content-Transfer-Encoding: 7bit\r\n";
$headers .= "From: " . $from . "\r\n";
$headers .= "CC: " .$cc . "\r\n";
$invio_conferma = mail($to, $subject, $message, $headers);
if ($invio_conferma)
{
echo("
E-mail inviata correttamente a:[b]$email[/b]");
}else{
echo("Contattare WebMaster");
}
dovrebbe funzionare