title: Adding search filters to my table columns
body: <p>I need someone to show me how you would create a simple table to search each column of data that I insert from this form. I am looking for the easiest way to create a table with search boxes that can filter each column. 
  DB: Mysql
  Field types: text
  Below shows the variables I am using for my form that posts the data to the database.</p>
  
  <pre><code>&lt;?php
  
  if (isset($_POST["submit"]) &amp;&amp; $_POST["submit"] == "Submit")
  {
      for ($count = 1; $count &lt;= 9; $count++)
      {
          $fields[$count] = "";
          if (isset($_POST["field" . $count . ""]))
          {
              $fields[$count] = trim($_POST["field" . $count . ""]);
              //echo $fields[$count] . "&lt;br /&gt;";
          }
      }
  
      $con = mysql_connect("local", "user", "pass");
      mysql_select_db("DB", $con);
  
      $fromzip = mysql_real_escape_string($_POST['fromzip']);
      $tozip = mysql_real_escape_string($_POST['tozip']);
  
      $insert = "INSERT INTO Carriers (`fromzip` ,`tozip` ,`date`) VALUES('$fromzip' ,'$tozip' , NOW())";
      mysql_query($insert) or die(mysql_error());
  
      $select = "SELECT `fromzip` ,`tozip` , FROM `Carriers` ORDER BY `date` DESC;";
      $result = mysql_query($select) or die(mysql_error());
  
  }
  ?&gt;
  &lt;style ="text-align: center; margin-left: auto; margin-right: auto;"&gt;&lt;/style&gt;
  &lt;/head&gt;
  &lt;body&gt;
  &lt;div
   style="border: 2px solid rgb(0, 0, 0); margin: 16px 20px 20px; width: 400px; background-color: rgb(236, 233, 216); text-align: center; float: left;"&gt;
  &lt;form action="" method="post";"&gt;
    &lt;div
    style="margin: 8px auto auto; width: 300px; font-family: arial; text-align: left;"&gt;&lt;br&gt;
    &lt;table style="font-weight: normal; width: 100%; font-size: 12px;"
   border="1" bordercolor="#929087" cellpadding="6" cellspacing="0"&gt;
     &lt;table
   style="font-weight: normal; width: 100%; text-align: right; font-size: 12px;"
   border="1" bordercolor="#929087" cellpadding="6" cellspacing="0"&gt;
      &lt;tbody&gt;
              &lt;tr&gt;
                &lt;td style="width: 35%;"&gt;Pick Zip:&lt;/td&gt;&lt;td&gt; &lt;input id="fromzip" name="fromzip" maxlength="50"
   style="width: 100%;" type="text"&gt;
          &lt;/tr&gt;
          &lt;tr&gt;
                &lt;td style="width: 35%;"&gt;Drop Zip:&lt;/td&gt;&lt;td&gt; &lt;input id="tozip" name="tozip" maxlength="50"
   style="width: 100%;" type="text"&gt;
          &lt;/tr&gt;
          &lt;/tbody&gt;
    &lt;/table&gt;
    &lt;p style="text-align: center;"&gt;&lt;input name="submit" value="Submit"
   class="submit" type="submit"&gt;&lt;/p&gt;
    &lt;/div&gt;
  &lt;/form&gt;
  &lt;/div&gt;
  &lt;p style="margin-bottom: -20px;"&gt;&amp;nbsp;&lt;/p&gt;
  &lt;/body&gt;
  </code></pre>