MySQL count and total

FishMmk

New Member
I have a table with a number of votes recorded in it, each vote goes against a post. What I want to be able to do is count the total occurances of each vote. Table looks like this:\[code\] vote ----- 1 2 3 1 2 3 4 5 2 2 2 2 ...and so on...\[/code\]How can I count the records, e.g. In that list 1x2, 2x6, 3x2, 4x1 and 5x1 times.
 
Back
Top