title: MySQL "unknown column" error message
body: <p>I am doing a PHP tutorial that uses the code below to insert a new user into a database. In the video tutorial I am following, the code works, but when I tried it I got the following error message </p>
  
  <pre><code>Database query failed: Unknown column
  'password' in 'field list'
  </code></pre>
  
  <p>Can someone explain what's wrong? Why is there only a problem with password? but it worked o.k. in the tutorial?</p>
  
  <pre><code>$sql = "INSERT INTO users (id, username, password, first_name, last_name) ";
  $sql .= "VALUES (1, 'kskoglund', 'secretpwd', 'Kevin', 'Skoglund')";
  $result = $database-&gt;query($sql);
  
  
  public function query($sql) {   $result
   = mysql_query($sql, $this-&gt;connection);
      return $result;
  }
  </code></pre>
  
  <p><img src="https://i.stack.imgur.com/0mBnu.png" alt="table"></p>
  
  <p><img src="https://i.stack.imgur.com/p4JFx.png" alt="password field in database"></p>