title: Mysql query problem
body: <p>I have a problem with my mysql query.</p>
  
  <p>My database:</p>
  
  <pre><code>sections
  id
  section_name
  
  grades
  id
  user_id
  section_id
  date
  grade
  </code></pre>
  
  <p>I want my data to be shown like this:</p>
  
  <p>Section_name grade</p>
  
  <p>But i wat want the grade to be the closest to todays date... 
  This is what i have so far but it doesn't show the latest grade. instead it orders by id (I guess)</p>
  
  <pre><code>SELECT *
  
                          FROM 
                          grades, 
                          sections 
  
                          WHERE 
                          sections.id = grades.section_id
  
                          AND
                          grades.user_id = '.$id.'
  
                          GROUP BY grades.section_id
  
                          ORDER BY grades.date DESC
  </code></pre>
  
  <p>EDIT: the $id variable is the user id from a session. </p>