title: MYSQL: count column if something if another column is equal to something else
body: <p>I have the following table:</p>
  
  <pre><code>----------------------------------------------
  |ID|Vote_Item_ID|User_ID|Country_code|   Vote|
  |01|   105102151|user1  |          CA|   like|
  |02|   105102151|user2  |          CA|dislike|
  |03|   105102151|user3  |          UK|dislike|
  |04|   105102151|user4  |          UK|   like|
  |05|   105102151|user5  |          UK|   like|
  ----------------------------------------------
  </code></pre>
  
  <p>What I need to do is create an SQL statement that creates an array which totals the likes and dislikes for each country...The script I am using this with has 175 countries, so would this be an inefficient way to about it?</p>
  
  <p>I'm not sure how to go about writing the Select statement, since I want the script to be reusable for many different "vote_item_id"s </p>
  
  <p>I am using PDO with a MYSQL database by the way.</p>
  
  <p>Thanks</p>