如何修复错误：查询是空的查询？ [重复]

Question

This question already has an answer here:

• MySQL Insert Where query 25 answers

I am updating the data in database from php and Getting Up Error:Query was empty with query. I badly need help. Thanks in Advance

<?php
$dbhost = 'localhost';
$dbuser = 'root';
$myDBname = 'jsv';
$conn = mysql_connect("localhost", "root");
mysql_select_db('jsv');
if(isset($_POST['update']))
{
$nam = $_POST['namnid'];
$mandag = $_POST['mandagid'];
$tisdag = $_POST['tisdagid'];
$torsdag = $_POST['torsdagid'];
$fredag = $_POST['fredagid'];

$sql = mysql_query("INSERT INTO jsv(CA_ID,Name,Address,Amount)  VALUES ('$mandag', '$tisdag', '$torsdag', '$fredag') WHERE Setup_Box_No = '$nam'", $conn);
if(!$sql )
{
  die('Could not update data: ' . mysql_error());
}
echo "Updated data successfully
";

}

mysql_close($conn);
?>

</div>

Answer 1

MySQL does not support a WHERE clause in an INSERT statement. This causes your query to fail & makes $sql false.

You will need to rewrite your INSERT statement.

This answer should give you more explanation on alternative queries.