PHP MySQL 选择字段并增加值

Question

我想获取指定字段的值(它是 INT)，然后递增该值，然后在 mysql 中更新它。我试过了，但没用。我对 MySQL 完全陌生。

            $attempts = mysql_fetch_array(mysql_query("SELECT attempts FROM employees WHERE lastname='$lastname'"));
            mysql_query("UPDATE employees SET attetmps='$attemtps++' WHERE lastname='$lastname'");

Answer 1

我建议: mysql_query("UPDATE employees SET attempts = attempts + 1 WHERE lastname = '".$lastname."'");