title: Order results by count with MySQL
body: <p>I have a table that stores a list of tags. I would like to be able to write a script that displays the tags a user uses the most. But, I am having trouble with writing the MySQL query to do so.</p>
  
  <p>Table Structure: </p>
  
  <pre><code>tag_id | user_id | tag
  --------------------------------
  1      | 1       | hiking   
  2      | 1       | fishing
  3      | 1       | hiking   
  4      | 1       | swimming
  5      | 1       | hiking   
  6      | 1       | swimming
  </code></pre>
  
  <p>What I have so far just outputs all of the tags:</p>
  
  <pre><code>$query= "SELECT tag FROM tags WHERE user_id='1'";
  </code></pre>
  
  <p>I would like the results to look like this:</p>
  
  <pre><code>hiking
  swimming
  fishing
  </code></pre>
  
  <p>Can I use an order by "Count" or something to achieve this?</p>