title: MYSQLi: Fatal error: Uncaught mysqli_sql_exception: Unknown column in 'field list'
body: <p>Only the name field is showing this error</p>
  <blockquote>
  <p>Fatal error: Uncaught mysqli_sql_exception: Unknown column 'Lettuce'
  in 'field list' in C:\xampp\htdocs\Nishrogo\AdminAddProduct.php:22
  Stack trace: #0 C:\xampp\htdocs\Nishrogo\AdminAddProduct.php(22):
  mysqli_query(Object(mysqli), 'CALL addnewprod...') #1 {main} thrown in
  C:\xampp\htdocs\Nishrogo\AdminAddProduct.php on line 22</p>
  </blockquote>
  <p>Procedure:</p>
  <pre><code>BEGIN
  INSERT INTO product (category,product_name,quantity, price,image,description) VALUES (category,pname,quantity,price,target, details);
  END
  </code></pre>
  <p>Code:</p>
  <pre><code>&lt;?php 
  
  if(isset($_POST['save'])){
  
      $name = $_POST['productName'];
      $category = $_POST['productCategory'];
      $quantity = $_POST['productQuantity'];
      $price = $_POST['productPrice'];
      $details = $_POST['productDetails'];
      $imageName = $_FILES['productImage']['name'];
  
  
      $target = 'image/'. $imageName;
      move_uploaded_file($_FILES['productImage']['tmp_name'], $target);
  
      $dbCart = mysqli_connect('localhost','root', '', 'nishorgo');
      if(mysqli_connect_errno()){
          echo 'could not connect to server.';
      }
  
      
      mysqli_query($dbCart,&quot;CALL addnewproduct( $category,$name, $quantity, $price, $target, $details)&quot;);
      
  
      header('location:AdminAddProduct.php');
  
  }
  ?&gt;
  </code></pre>