rondog Posted December 19, 2007 Share Posted December 19, 2007 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! Quote Link to comment Share on other sites More sharing options...
rondog Posted December 19, 2007 Author Share Posted December 19, 2007 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"); Quote Link to comment Share on other sites More sharing options...
roopurt18 Posted December 19, 2007 Share Posted December 19, 2007 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 Quote Link to comment Share on other sites More sharing options...
rondog Posted December 19, 2007 Author Share Posted December 19, 2007 Ahh! ok I gotcha..that worked like a charm :] thanks Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.