title: PHP displaying SQL data and amount of times repeated
body: <p>I have a table called <strong>'event1'</strong> containing info such as:</p>
  
  <p><strong>| Name | Age | Nationality |</strong></p>
  
  <p>I want to display, for instance, a nationality and how many times a certain nationality is repeated. </p>
  
  <p>So for example: <br>
  India - 5 <br>
  Australia - 10 <br> 
  US - 10</p>
  
  <p>The query I came up with was </p>
  
  <pre><code>SELECT nationality, COUNT(nationality) AS Total
  FROM event1 GROUP BY nationality HAVING COUNT(nationality)&gt;=1
  </code></pre>
  
  <p>I'm not sure if that is correct.</p>
  
  <p>How can I display the above example using PHP? </p>