title: How to fix error in html
body: <p>I have created one HTML form and i have written php script also to connect to database. If i enter data in form and hit UPDATE button in form, its showing error like below,   </p>
  
  <pre><code>&lt;form action="process.php" method="Post"/&gt;
  &lt;style&gt;
  p{
      float:left;
  }
  &lt;/style&gt;
  &lt;fieldset&gt;
      &lt;legend align="center"&gt;&lt;FONT color=default&gt;Enter information Of SO's&lt;/legend&gt;
      &lt;p align="center"&gt; 
        &lt;label for="SO_ID"&gt;&lt;FONT color=white&gt;SO_ID&lt;/label&gt;
        &lt;br/&gt;
        &lt;input type="varchar" id="SO_ID" name="SO_ID"required/&gt;
  &lt;/p&gt;
  
  &lt;p align="center"&gt;
    &lt;label for="No.of_samples"&gt;&lt;FONT color=white&gt;No.of samples&lt;/label&gt;
    &lt;br/&gt;
    &lt;input type="int" id="No.of_samples" name="No.of_samples"required/&gt;
  &lt;/p&gt;
  
  &lt;p align="center"&gt;
    &lt;label for="Sample name"&gt;&lt;FONT color=white&gt;Sample name&lt;/label&gt;
    &lt;br /&gt;
    &lt;input type="varchar" id="Sample name" name="Sample name"required/&gt;
  &lt;/p&gt;
  
  
  &lt;p align="center"&gt;
    &lt;label for="Client name"&gt;&lt;FONT color=white&gt;Client name&lt;/label&gt;
    &lt;br /&gt;
    &lt;input type="text" id="Client name" name="Client name"required/&gt;
  &lt;/p&gt;
  
  
  &lt;p align="center"&gt; 
    &lt;label for="Institution"&gt;&lt;FONT color=white&gt;Institution&lt;/label&gt;
    &lt;br/&gt;
    &lt;input type="text" id="Institution" name="Institution"required/&gt;
  &lt;/p&gt;
  &lt;p align="center"&gt; 
    &lt;label for="Run number "&gt;&lt;FONT color=white&gt;Run number &lt;/label&gt;
    &lt;br/&gt;
    &lt;input type="int" id="Run number" name="Run number"required/&gt;
  &lt;/p&gt;
  &lt;p align="center"&gt; 
    &lt;label for="Obtained reads"&gt;&lt;FONT color=white&gt;Obtained reads&lt;/label&gt;
    &lt;br/&gt;
    &lt;input type="int" id="Obtained reads" name="Obtained reads"required/&gt;
  &lt;/p&gt;
  &lt;p align="center"&gt; 
    &lt;label for="Re run Info"&gt;&lt;FONT color=white&gt;Re run Info&lt;/label&gt;
    &lt;br/&gt;
    &lt;input type="text" id="Re run Info" name="Re run Info"required/&gt;
  &lt;/p&gt;
  &lt;p align="center"&gt; 
    &lt;label for="Total reads"&gt;&lt;FONT color=white&gt;Total reads&lt;/label&gt;
    &lt;br/&gt;
    &lt;input type="int" id="Total reads" name="Total reads"required/&gt;
  &lt;/p&gt;
  &lt;p align="center"&gt; 
    &lt;label for="Run date"&gt;&lt;FONT color=white&gt;Run date&lt;/label&gt;
    &lt;br/&gt;
    &lt;input type="date" id="Run date" name="Run date"required/&gt;
  &lt;/p&gt;
  &lt;p align="center"&gt; 
    &lt;label for="Raw data location"&gt;&lt;FONT color=white&gt;Raw data location&lt;/label&gt;
    &lt;br/&gt;
    &lt;input type="varchar" id="Raw data location" name="Raw data location"required/&gt;
  &lt;/p&gt;
  &lt;p align="center"&gt; 
    &lt;label for="Analyst"&gt;&lt;FONT color=white&gt;Analyst&lt;/label&gt;
    &lt;br/&gt;
    &lt;input type="varchar" id="Analyst" name="Analyst"required/&gt;
  &lt;/p&gt;
  &lt;p align="center"&gt; 
    &lt;label for="Mentor"&gt;&lt;FONT color=white&gt;Mentor&lt;/label&gt;
    &lt;br/&gt;
    &lt;input type="text" id="Mentor" name="Mentor"required/&gt;
  &lt;/p&gt;
  &lt;p align="center"&gt; 
    &lt;label for="Analysis start date"&gt;&lt;FONT color=white&gt;Analysis start date&lt;/label&gt;
    &lt;br/&gt;
    &lt;input type="date" id="Analysis start date" name="Analysis start date"required/&gt;
  &lt;/p&gt;
  &lt;p align="center"&gt; 
    &lt;label for="Analysis end date"&gt;&lt;FONT color=white&gt;Analysis end date&lt;/label&gt;
    &lt;br/&gt;
    &lt;input type="date" id="Analysis end date" name="Analysis end date"required/&gt;
  &lt;/p&gt;
  &lt;p align="center"&gt; 
    &lt;label for="Report location"&gt;&lt;FONT color=white&gt;Report location&lt;/label&gt;
    &lt;br/&gt;
    &lt;input type="varchar" id="Report location" name="Report location"required/&gt;
  &lt;/p&gt;
  
  &lt;/fieldset&gt;
  &lt;div style="text-align:center"&gt; 
  &lt;button action= "process.php" method="post" &gt;
     &lt;img alt="ok" src=
     "http://www.blueprintcss.org/blueprint/plugins/buttons/icons/tick.png" /&gt; 
     UPDATE
    &lt;/button&gt;
  
  
  &lt;/form&gt;  
  </code></pre>
  
  <p>the above script is saved in "process.html"  </p>
  
  <p>now below PHP script.  </p>
  
  <pre><code>&lt;?php
    define('DB_NAME','ProcessTrackingSystem');
    define('DB_USER','root');
    define('DB_PASSWORD','');
    define('DB_HOST','localhost');
  
   $link=mysql_connect(DB_HOST,DB_USER,DB_PASSWORD);
  
  if(!$link){
  
   die('couldnot connect:'.mysql_error());
  }
  
    $db_selected=mysql_select_db(DB_NAME,$link);
  
      if(!$db_selected){
   die('cannot use'.DB_NAME.':'.mysql_error());
  }
  
  $value1 =$_POST['SO_ID'];
  $value2 =$_POST['No.of samples'];
  $value3 =$_POST['Sample name'];
  $value4 =$_POST['Client name'];
  $value5 =$_POST['Institution'];
  $value6 =$_POST['Run number '];
  $value7 =$_POST['Obtained reads'];
  $value8 =$_POST['Re run Info'];
  $value9 =$_POST['Total reads'];
  $value10 =$_POST['Run date'];
  $value11 =$_POST['Raw data location'];
  $value12 =$_POST['Analyst'];
  $value13 =$_POST['Mentor'];
  $value14 =$_POST['Analysis start date'];
  $value15 =$_POST['Analysis end date'];
  $value16 =$_POST['Report location'];
  
  
  $sql="INSERT INTO ProcessDetails (SO_ID, No.of_samples, Sample_name, Client_name, Institution,  Run_number, Obtained_reads, Re_run_Info, Total_reads, Run_date, Raw_data_location, Analyst, Mentor, Analysis_start_date, Analysis_end_date, Report_location) VALUES ('$value1', '$value2', '$value3', '$value4', '$value5','$value6', '$value7', '$value8', '$value9', '$value10','$value11', '$value12', '$value13', '$value14', '$value15','$value16')";
  
  if(!mysql_query($sql)){
   die('error:'.mysql_error());
  }
  
  header('Location:process.html');
  
  
  mysql_close();
  ?&gt;  
  </code></pre>
  
  <p>now if i enter the data into html form, its showing error that "error:Unknown column 'No.of_samples' in 'field list'".
  anyone help me out to fix this error and get desired output.<br>
  Thanks in advance....</p>