php mysql用户信息更新

Question

if ($email != $CURUSER["email"]) {
if (!validemail($email))
    bark( _("Klaida! Panašu, kad klaidingai įvedei email adresą!") );
$r = do_mysql_query("SELECT id FROM users WHERE email=" . sqlesc($email)) or sqlerr();
if (mysql_num_rows($r) > 0)
    bark( sprintf( _("Toks emailas adresas %s jau naudojamas!"), $email) );
           ####
    $date = date("Y-m-d");
    $modcomment_email = "{$date} - E-mail pakeistas, pakeitė: {$CURUSER['username']}";
    $modcomment_email = mysql_real_escape_string($modcomment_email);
    do_mysql_query("UPDATE users SET modcomment = '$modcomment_email' where id = ".$CURUSER['id']) or sqlerr(__FILE__, __LINE__);
          #####
$changedemail = 1;
 }

After this script executed row updated, but old data deleted. How update row, but keep old data ?

Answer 1

You're using an UPDATE command. This does, as you've observed, modify the row(s) that match your WHERE clause.

If you'd like to keep the list of previous $modcomment_emails then you'll need to use an INSERT into some table and then make sure you're selecting the most recent record out when you do your SELECT to output the data. You could add a column to keep the date of the insert as something to ORDER BY.