Count how many times a duplicate exists...

bdezso

I have a script that stores questions asked in a database and I want to display the most asked questions in a table. So far I have gotten to display all doubles but I want to display how many times they appear in my database.

Here is my code so far:

$double = mysql_query("SELECT question FROM question GROUP BY question HAVING count(*) > 1")
or die(mysql_error());

How would I put the number of times those entries appear?

NogDog

I think you could just add the count to the column list, too:

SELECT question, COUNT(*) AS `count` FROM . . .

bdezso

NogDog;10913961 wrote:
I think you could just add the count to the column list, too:
SELECT question, COUNT(*) AS `count` FROM . . .

Yep I found it. I used:

$double = mysql_query("SELECT question, COUNT(question) AS cnt FROM question GROUP BY question HAVING COUNT(question) > 1 ORDER BY cnt DESC");