title: Aggregate MYSQL functions getting a value in the same row
body: <pre><code>$query = mysql_query("SELECT *, MAX(date_time) FROM messages 
                        WHERE user_to='$current_user' OR user_from='$current_user'
                        GROUP BY conversation 
                        ORDER BY date_time DESC LIMIT 0,5") or die(mysql_error());
  
  echo $message['MAX(date_time)'];
  </code></pre>
  
  <p>How can I display the column 'content' that is in the same row as the date_time being selected here, so the time matches with the message? Would it be something like</p>
  
  <pre><code>echo $message['MAX(content)'];
  </code></pre>
  
  <p>I am trying to have 'messages' in groups (called conversations) and I want to display the most recent message. It is currently displaying the most recent time but not the most recent message.</p>
  
  <p>Thanks.</p>