title: MySQL entries sorted by date in wrong order
body: <p>Using a MySQL <code>SELECT</code> query via PHP, I would like to order my entries by date. The query I'm using is:</p>
  
  <pre><code>$query = "SELECT title, file, oblong_pic, square_pic,
  DATE_FORMAT(date, '%W %d %M %Y') AS date
  FROM dyhamb ORDER BY date DESC";
  </code></pre>
  
  <p>I have four entries dated: 24/7/2012, 1/7/2012, 5/6/2012 and 10/4/2012 and would like them to be displayed in that order however they are being displayed as: 24/7/2012, 10/4/2010, 5/6/2012 and 1/7/2012.</p>
  
  <p>I can only think that I've set my query up incorrectly somehow but I don't see where I've gone wrong.</p>