title: Filter database fields by date
body: <p>I have a page that shows user activity, I have built a form where the user can filter this by date. </p>
  
  <p>Here is the form</p>
  
  <pre><code>&lt;form action='filter_activity.php' method='get'&gt;
      From: &lt;input type='text' name='from' value='dd/mm/yyyy'&gt;
      To: &lt;input type='text' name='to'  value='dd/mm/yyyy'&gt;
      &lt;input type='submit' value='Filter'&gt; 
  </code></pre>
  
  <p>Here is the <code>filter_activity.php</code> page:</p>
  
  <pre><code>$from=$_GET["from"];
  $to=$_GET["to"];
  
  $result=mysql_query("SELECT * FROM member WHERE personID=$user AND created between $from and $to ");
  </code></pre>
  
  <p>However this shows nothing, can anyone help?</p>