I have a table of votes with four fields, a primary key, and userID, that are just there for tracking purposes. But then I have questionID and vote fields. For each question, a user could pick a number of it's importance from 1 to 5. That number is what gets stored in the vote field.
So, now I want to tabulate the votes. I thought I could just do a count with a group by but that isn't working. What I want to do is for each question, get a count of how many ones, how many twos, how many threes, etc. Advice? --ja -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
