title: PHP, MySQL error: Column count doesn't match value count at row 1
body: <p>I'm getting this error:</p>
  
  <p><code>Column count doesn't match value count at row 1</code></p>
  
  <p>From the following code:</p>
  
  <pre><code>$name = $_GET['name'];
  $description = $_GET['description'];
  $shortDescription = $_GET['shortDescription'];
  $ingredients = $_GET['ingredients'];
  $method = $_GET['method'];
  //$image = $_GET['image'];
  $username = $_GET['username'];
  $length = $_GET['length'];
  $dateAdded = uk_date();
  $conn = mysql_connect('localhost', 'dbname', 'pass');
  mysql_select_db('dbname');
  $query = sprintf("INSERT INTO dbname (id, Name, Description, shortDescription, Ingredients, Method, Length, dateAdded, Username) VALUES ('', '%s', '%s', '%s', '%s', '%s', '%s', '%s')",
      mysql_real_escape_string($name),
      mysql_real_escape_string($description),
      mysql_real_escape_string($shortDescription),
      mysql_real_escape_string($ingredients),
      //mysql_real_escape_string($image),
      mysql_real_escape_string($length),
      mysql_real_escape_string($dateAdded),
      mysql_real_escape_string($username));
  
      $result = mysql_query($query) or die(mysql_error());
  </code></pre>
  
  <p>What does the error mean?</p>