title: Order by date MySQL query ordering by day only, not full date
body: <p>I have a query where I'm trying to sort by most recent date at top, down to oldest result at bottom. This is the query</p>
  
  <pre><code>SELECT headline, story, DATE_FORMAT(date, "%d-%M-%Y") AS date, 
  name, logo, tpf_parks.park_id, url, alt, description
  FROM tpf_news
  INNER JOIN tpf_parks ON tpf_news.park_id = tpf_parks.park_id 
  LEFT JOIN tpf_images ON tpf_news.news_id = tpf_images.news_id 
  ORDER BY date DESC
  </code></pre>
  
  <p>The results are ordered wrong though, it is sorting it by day only so results are ordered like this: <code>25-march-2013, 23-april-2013, 19-febuary-2013, 10-may-2013</code> etc. I think its because the way I am displaying the date <code>DATE_FORMAT(date, "%d-%M-%Y") AS date</code>, but I have no idea how to fix it. Any ideas?</p>