title: How can I get this database to order before the GROUP BY
body: <p>I made a website for golf scorecards. The page I am working on is the players profile. When you access a players profile, it shows each course in order of last played (DESC). Except, the order of last played is jumbled due to the ORDER BY command below. Instead, when it GROUPs, it takes the earliest date, rather than the most recent.</p>
  
  <p>After the grouping is done, it correctly shows them in order (DESC)... just the wrong order due to the courses grouping by date_of_game ASC, rather than DESC. Hope this isn't too confusing..  Thank you.</p>
  
  <pre><code>$query_patrol321 = "SELECT t1.*,t2.* FROM games t1 LEFT JOIN scorecards t2 ON t1.game_id=t2.game_id WHERE t2.player_id='$player_id' GROUP BY t1.course_id ORDER BY t1.date_of_game DESC";
  $result_patrol321 = mysql_query($query_patrol321) or die ("&lt;br /&gt;&lt;br /&gt;There's an error in the MySQL-query: ".mysql_error());
  while ($row_patrol321 = mysql_fetch_array($result_patrol321)) {
      $player_id_rank = $row_patrol321["player_id"];
      $course_id = $row_patrol321["course_id"];
      $game_id = $row_patrol321["game_id"];
      $top_score = $row_patrol321["total_score"];
  </code></pre>