Database table:
+----------------------------------------------+
| vote_id | user_id | vote_type | fieldset_id  |
+----------------------------------------------+
|   1     |  1      |  up       |  111         |
|   2     |  2      |  up       |  111         |
|   3     |  3      |  down     |  111         |
|   4     |  4      |  up       |  111         |
+----------------------------------------------+

select vote_type,count(vote_type) as total_vote
   from vote_mst
   where fieldset_id='111'
   group by vote_type

+-------------------------+
| vote_type  | total_vote |
+-------------------------+
|   up       |  3         |
|   down     |  1         |
+-------------------------+