title: Sorting events by event date - how?
body: <p>I have at table where I store all events. In that table I have a column named "event_date". The person who creates a event has to type the date like this:d/m/Y - example: 27/02/2013.</p>
  
  <p>But when I try to sort the results by the event_date ASC, it doesn't come out in the desired order. I have even tried ordering it with UNIX_TIMESTAMP(event_date), but it doesn't solve my problem either.</p>
  
  <p>How can I fix this?</p>
  
  <p>There is one solution; when a person creates an event, I can convert it to a timestamp. But isn't it possible to sort it correctly as it is now?</p>
  
  <p>Thanks in advance.</p>