title: PHP/MySQL - Count number of sales made and display that number and who sold them
body: <p>I'm working on a PHP application for University which pretends I buy and resell a specific item to/from countries.
  I have a table which contains transaction IDs and the names of the countries that made them.</p>
  
  <p>I've been trying to count up the number of times a specific country's name appears in the database table then print out a table on the webpage showing each countries name and the number of times they appear in the table like below, but I can't find any examples of this kind of thing anywhere, they're always too different to be of much help. I would also like to order the table by max to min count and also be able to limit the number of countries shown using radio buttons (which I've already got working).</p>
  
  <pre>
  countryName | numberOfSales
  Belize      |       10
  Brazil      |        6
  Cameroon    |       64
  Colombia    |       23
  Costa Rica  |       47
  </pre>