PHP UPDATE'字段列表'中的未知列'名称'

Question

I seem to be having an issue when it come to updating a database using PHP. I keep getting the error:

ERROR: Could not able to execute UPDATE settings SET value='0' WHERE id='2'. Unknown column 'value' in 'field list'

but the Column "value" does exist, and I have tried what people have previously said when asking the same question about it error but nothing has worked so far. what would be the reason behind this not working?

Full Code:

require 'config.php';

$link = mysqli_connect("LocalHost", "PSRPCADM", "999989Ki9?", "PSRPC");



// Check connection

if($link === false){

    die("ERROR: Could not connect. " . mysqli_connect_error());

}



// Escape user inputs for security
if(isset($_POST['Monday']) &&
$_POST['Monday'] == 'Yes')
{
$monday = "1";
}
else
{
$monday = "0";
}   



// attempt insert query execution


$sql = "UPDATE settings SET value='$monday' WHERE id='2'";




if(mysqli_query($link, $sql)){

echo "it worked";


} else{

    echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);

}



// close connection

// close connection

mysqli_close($link);

Answer 1

Try This

$sql = "UPDATE `settings` SET `value`='".$monday."' WHERE id='2'";

hope this help