[SOLVED] I need a while loop to count how many of the same results in the table

[rondog]

Basically I have a test that submits wrong answers to the DB. I have a tracking page that sees what questions were answered incorrectly.

 

My current while loop just lists out all the questions that were answered wrong even if their are duplicates. I want to have a sum of the ones that are the same.

 

so like:

QuestionTimes answered wrong

Question 124

Question 238

Question 312

Question 356

 

my table is pretty simple..it has 3 fields..

 

id, testNum, and testQuestion

 

thanks a lot guys!

[rondog]

this is my query if it help..if I execute the query in phpMyAdmin it does exactly what I want it to do, but I dont know how to display it in php

 

		$sql = mysql_query("SELECT testQuestion, COUNT(testQuestion) FROM synTests WHERE testNum = '$test' GROUP BY testQuestion");

[roopurt18]

Give the COUNT() column an alias, then you refer to it just like any other column:

SELECT testQuestion, COUNT(testQuestion) AS `nCount` FROM synTests WHERE testNum = '$test' GROUP BY testQuestion

[rondog]

Ahh! ok I gotcha..that worked like a charm :] thanks