title: When i am inert data in to dataabse then show me thats error Column count doesn't match value count at row 1
body: <p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-html lang-html prettyprint-override"><code>&lt;?php
  
          ///////////////////////////////////////////////Registration by form//////////////////////////////
          if(isset($_POST['add'])){
          
      
          $sr_no=$_POST['sr_no'];
          $roll_no=$_POST['roll_no'];
        
          $o_tmark=$_POST['o_tmark'];
          $o_vmark=$_POST['o_vmark'];
          $yoga_tmark=$_POST['yoga_tmark'];
          $yoga_vmark=$_POST['yoga_vmark'];
      
          $s_tmark=$_POST['s_tmark'];
          $s_vmark=$_POST['s_vmark'];
          $i_tmark=$_POST['i_tmark'];
          $i_vmark=$_POST['i_vmark'];
         $o_totalmark=$o_tmark+$o_vmark;
         $yoga_totalmark=$yoga_tmark+$yoga_vmark;
         $s_totalmark=$s_tmark+$s_vmark;
         $i_totalmark=$i_tmark+$i_vmark;
       
          $date = date('m/d/y');
          $sub1='Obstetrics';
    $sub2='Nat.Yoga Treatment';
    $sub3='Surgery';
    $sub4='Iridology';
  if($roll_no !="")
  {
   
  $rs=mysqli_query($con,"select * from `bnysfinalyear` where roll_no='$roll_no'");
  if (mysqli_num_rows($rs)&gt;0)
  {
    
     echo "&lt;script type='text/javascript'&gt; alert('User Already Registered'); &lt;/script&gt;";
   exit;
  } 
  else
  {
          mysqli_query($con,"INSERT into `bnysfinalyear`(`sr_no`,`roll_no`,`o_tmark`,`o_vmark`,`yoga_tmarks`,`yoga_vmarks`,`s_tamrk`,`s_vamrk`,`ir_tmark`,`ir_vmark`,`o_totalmark`,`yoga_totalmark`,`s_totalmark`,`ir_totalmark`,`date`,`sub1`,`sub2`,`sub3`,`sub4`)
          values('$sr_no','$roll_no','$o_tmark','$o_vmark','$yoga_tmark','$yoga_vmark','$s_tmark','$s_vmark','$i_tmark','$i_vmark','$o_totalmark','$yoga_totalmark','$s_totalmark','$i_totalmark','$date','$sub1','$sub2','$sub3','$sub4')")or die(mysqli_error($con));
          
          $msg='&lt;div class="alert alert-success"&gt;
    &lt;strong&gt;Registration!&lt;/strong&gt; Successfuly Submited.
  &lt;/div&gt;
  ';
      
          
          }
          
  }
    }
          ?&gt;
  DATABASE 
  `id`, `sr_no`, `roll_no`, `student_name`, `enrol_no`, `o_tmark`, `o_vmark`, `ir_tmark`, `ir_vmark`, `yoga_tmarks`, `yoga_vmarks`, `s_tamrk`, `s_vamrk`, `o_totalmark`, `ir_totalmark`, `yoga_totalmark`, `s_totalmark`, `date`, `sub1`, `sub2`, `sub3`, `sub4`, `status` </code></pre>
  </div>
  </div>
  
  Whene i am insert data into database show than show me error "Column count doesn't match value count at row 1"this ..
  I am check allredy all database field and count all all fields but all fields are right 
  i am check all the fields but i don't show any error in any place please check it  and help him to solve this problem </p>