Mysql更新错误

Question

我得到这个错误:未知的列'richard‘在'where子句’在这段代码中：

if(isset($_POST['Zabanovat'])){;
    $nick = $_POST['nick'];
    $ban = $_POST['ban'];
    mysql_query("UPDATE TABLE Set usr_unban = $ban   WHERE usr_nick =  $nick    ") OR die(mysql_error());
}

echo "<form method=\"post\">";

echo "<div class=\"formatLabel\"><label for=\"nick\"><h2>Zadejte jméno banovaného účtu</h2></label></div>";
echo "<div class=\"formatContent\"><input type=\"text\" id=\"nick\" name=\"nick\"></div>";

    echo "<div class=\"formatLabel\"><label for=\"ban\"><h2>Zadejte datum unbanu (dd.mm.yyyy)</h2></label></div>";
echo "<div class=\"formatContent\"><input type=\"text\" id=\"ban\" name=\"ban\"></div>";

echo "<div class=\"formatSubmit\"><input type=\"submit\" value=\"Zabanovat\" name=\"Zabanovat\"></div>";

echo "</form>";

Answer 1

如果变量不包含数值，则必须将变量放在单引号内。

mysql_query("UPDATE TABLE Set usr_unban = '$ban' WHERE usr_nick = '$nick'") OR die(mysql_error());

Answer 2

我认为您在输入查询时遗漏了表名，除非您的表名为" table "：

mysql_query("UPDATE TABLE Set usr_unban = $ban WHERE usr_nick = $nick ") OR die(mysql_error()); }

应该是：

mysql_query("UPDATE **TABLE_NAME** Set usr_unban = $ban WHERE usr_nick = $nick ") OR die(mysql_error()); }

记住，SQL中的UPDATE类是：

UPDATE "table_name"
SET "column_1" = [new value]
WHERE {condition}