title: MySQL select only where Timestamp is from last 10 days
body: <p>I want to limit my query to results that have been entered in the last 10 days. The TIMESTAMP column is called Date. How do I do it?</p>
  
  <pre><code>$result = mysql_query("SELECT * FROM Posts WHERE (City = '$city2') ORDER by Comments DESC LIMIT 5");
  </code></pre>
  
  <p>Thanks</p>