title: PHP MySQL - getting "days and hours" left of DATETIME
body: <p>I have a MYSQL query that selects all rows that are less than 60 days old.  I would like to display on my PHP page "x days and y hours left".  What's the easiest way to do this?</p>
  
  <pre><code>SELECT u.username, u.id, u.score, s.genre, s.songid, s.songTitle, s.timeSubmitted, s.userid, s.insWanted, s.bounty, COUNT(p.songid)
   FROM  songs s
   LEFT JOIN users u
   ON u.id = s.userid
   LEFT JOIN posttracks p
   ON s.songid = p.songid
   WHERE paid=1 AND s.timeSubmitted &gt;= ( CURDATE() - INTERVAL 60 DAY )
   GROUP BY s.timeSubmitted DESC
   LIMIT 15
  </code></pre>