title: Display a single columns in while loop using PHP
body: <p>I searched a lot still could not find satisfactory answer. Please have a look at the sample mysql table below:</p>
  
  <pre><code>id    |    Name        |    Country
  1     |    User1       |    India
  2     |    User2       |    India
  3     |    User3       |    India
  4     |    User4       |    Australia
  5     |    User5       |    Australia
  </code></pre>
  
  <p>I want to display above table in a while loop using PHP, something like below:</p>
  
  <pre><code>Country Name:         |        Total Members From The Country:
  India                 |        3
  Australia             |        2
  </code></pre>
  
  <p>I only want to target and display only one column/field i.e "country". Can anyone please share the query code here so I can proceed with my work and thank you for  your time.</p>