joined:May 8, 2013
I could use a little help guys, can't seem to find an answer.
I have a column in a table with varying numbers ranging from 1 to 3.
I need to count how many rows I have for each number and then show a percentage for each.
I've got the totals for each but not sure how to proceed with percentages. Do I need a new query or do this with php after I get the totals? I would like to accomplish this in one query if its possible.
Here is what I have so far:
$query = "SELECT col, COUNT(col) FROM tbl WHERE id = '10' GROUP BY col DESC";
The result is:
number 3 found 12 times
number 2 found 5 times
number 1 found 35 times
Thank you in advance for your help!