title: PHPmyAdmin and sorting a database table
body: <p>[edit]: I'm terribly sorry for my timing on asking this question.  I've just discovered that you can use the command</p>
  
  <pre><code>"ORDER BY `table`.`table_col` DESC" 
  </code></pre>
  
  <p>to order your results from a MySQL table.</p>
  
  <p>I am working on creating forum and I am using ajax to get results from a database table.
  I would like to order these results before I display them on the page, sorted by a timestamp of the current day of the month.</p>
  
  <p>the day for each post is a two digit number in my MySQL table i.e. <code>06</code> for post one, <code>09</code> for post two, <code>21</code> for post 3</p>
  
  <p>I know how to write the script to sort these, but I would like to know if there is an easier way. </p>
  
  <p>Can I simply set the table in my phpMyAdmin to keep each post sorted in order from least to greatest on the value of the day column?</p>