title: add a jquery date picker to php list
body: <p>I have a mysql database table which contains a error code, date and mail address.</p>
  
  <p>My script below displays a basic list as per the screenshot, </p>
  
  <p><img src="https://i.stack.imgur.com/gval8.png" alt="Script displays as follows"></p>
  
  <p>I would like to be able to filter by date, I am hoping to use jquery date picker.</p>
  
  <p>The idea being, only show entries where the date matches that in the jquery date picker.</p>
  
  <p>The php code used to display the list:</p>
  
  <pre><code>    &lt;?php
  
  // Add  Logo
  $image = "logo.png";
  $width = 300;
  $height = 280;
  echo '&lt;img src="'.$image.'" style=width:"' . $width . 'px;height:' . $height . 'px;"&gt;';
  
  // Make a MySQL Connection
  mysql_connect("localhost", "username", "password") or die(mysql_error());
  mysql_select_db("pmta_reporting") or die(mysql_error());
  
  // Get all the data from the "example" table
  $result = mysql_query("SELECT * FROM address")
  or die(mysql_error());
  
  echo "&lt;table border='1'&gt;";
  echo "&lt;tr&gt; &lt;th&gt;Error&lt;/th&gt; &lt;th&gt;Date&lt;/th&gt; &lt;th&gt;Mail Address&lt;/th&gt; &lt;/tr&gt;";
  // keeps getting the next row until there are no more to get
  while($row = mysql_fetch_array( $result )) {
          // Print out the contents of each row into a table
          echo "&lt;tr&gt;&lt;td&gt;";
          echo $row['code'];
          echo "&lt;/td&gt;&lt;td&gt;";
          echo $row['date'];
          echo "&lt;/td&gt;&lt;td&gt;";
          echo $row['address'];
          echo "&lt;/td&gt;&lt;/tr&gt;";
  }
  
  echo "&lt;/table&gt;";
  // disconnect from the database
  
      mysql_close();
  ?&gt;
  </code></pre>
  
  <p>The code I am using for the date picker is</p>
  
  <pre><code>&lt;!doctype html&gt;
  
  &lt;html lang="en"&gt;
    &lt;head&gt;
      &lt;meta charset="utf-8" /&gt;
      &lt;title&gt;jQuery UI Datepicker - Default functionality&lt;/title&gt;
      &lt;link rel="stylesheet" href="http://code.jquery.com/ui/1.10.2/themes/smoothness/jquery-ui.css" /&gt;
      &lt;script src="http://code.jquery.com/jquery-1.9.1.js"&gt;&lt;/script&gt;
      &lt;script src="http://code.jquery.com/ui/1.10.2/jquery-ui.js"&gt;&lt;/script&gt;
      &lt;link rel="stylesheet" href="/resources/demos/style.css" /&gt;
      &lt;script&gt;
         $(function() {
            $( "#datepicker" ).datepicker();
         });
     &lt;/script&gt;
    &lt;/head&gt;
    &lt;body&gt;
       &lt;p&gt;Date: &lt;input type="text" id="datepicker" /&gt;&lt;/p&gt;
    &lt;/body&gt;
  &lt;/html&gt;
  </code></pre>
  
  <p>How can I add the jquery date picker to the script so that when a user selects a date the results shown on the page only display the date selected by the user?</p>