title: How to SELECT records and display text along with COUNT?
body: <p>[I am using an example in this question, the real problem I have is very similar, but it would be too complicated to write it down here ;) ]</p>
  
  <p>So, I have a database table:</p>
  
  <pre><code>  id   |   text
  -------+------------
    1    |   Google 
    2    |   Yahoo
    3    |   Google
    4    |   Bing
    5    |   Yahoo
    6    |   Google
    7    |   Yahoo
    8    |   Google
  </code></pre>
  
  <p>I want to SELECT them all and then display them like this:</p>
  
  <pre><code>Google 4
  Yahoo 3
  Bing 1
  </code></pre>
  
  <p>So I want to order the phrases by the number of appearances in the database...
  It might sound a bit complicated... But I think my problem can be understood with the example.</p>
  
  <p>So what should I do? What is the appropriate code for this in PHP/MySQL?</p>