PHP MySQL calculate how many rows have the same data

Question

Ok, well I know I can just say WHERE example='vrvrv' but that's not the case. Ok I have a rating system and whenever a page is rated the page id and the date it was rated is sent to a table in my database. Now on the homepage I want to determine top rated that day, I can easily compare dates but I'm not quite sure how to count how many rows have the same value in the project_id column. It would be amazing if someone could help me out, thanks!

Mihai Iorga · Accepted Answer · 2012-10-08 06:34:36Z

2

You can use GROUP and COUNT to get duplicates:

SELECT count(`project_id`) AS `duplicates` FROM `table` GROUP BY `project_id` HAVING `duplicates` > 1

edited Oct 8, 2012 at 6:34

answered Oct 6, 2012 at 20:36

Mihai Iorga

39.8k17 gold badges109 silver badges109 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

NardCake Over a year ago

Wait, what exactly is id your selecting?

Mihai Iorga Over a year ago

I just assumed an ID ... you can skip that

Collectives™ on Stack Overflow

PHP MySQL calculate how many rows have the same data

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related