title: PHP script not updating mysql table
body: <p>this script is simply not working... can anyone tell me what I'm doing wrong?</p>
  
  <pre><code>$id = $_POST['id'];
  $name = $_POST['name'];
  $date = $_POST['date'];
  $shortdesc = $_POST['shortdesc'];
  $link = $_POST['link'];
  $target = $_POST['target'];
  $sort = $_POST['sort'];
  $html = $_POST['html'];
  
      include('appvars.php');
  
      $query = "UPDATE insight SET name='".$name."' AND SET date='". $date . "' AND SET html='" . $html . "' AND SET shortdesc='" . $shortdesc . "' AND SET link='" . $link . "' AND SET target='" . $target . "' AND SET sort='" . $sort . "' WHERE id='" . $id . "'";
  
      mysqli_query($dbc, $query);
  </code></pre>