title: print mysql date using smarty
body: <p>i put date in mysql database with this method <code>2012-08-02 02:20:05</code>. now, how to print in my page using smarty. </p>
  
  <p>mycode : ( NOTE: send_date is name of row )</p>
  
  <pre><code>$sql = "SELECT m.*, s.photo, s.gender
         FROM mail AS m, signup AS s
         WHERE m.receiver = '" .mysql_real_escape_string($username). "'
         AND m.sender = s.username AND inbox = '1' AND status = '1'
         ORDER BY send_date DESC LIMIT " .$limit;
  $rs  = $conn-&gt;execute($sql);
  </code></pre>