johny30238 Posted December 23, 2010 Share Posted December 23, 2010 Alright, I need to find a way to display the top ten duplicated rows for a table in my database. I have tried multiple methods but I have failed. Can you please assist me with this problem. I currently run a query in phpmyadmin to get the result, but i cant figure out how to properly code the php script. Link to comment https://forums.phpfreaks.com/topic/222481-counting-duplicate-rows-and-displaying-results/ Share on other sites More sharing options...
litebearer Posted December 23, 2010 Share Posted December 23, 2010 show us what you have tried thus far Link to comment https://forums.phpfreaks.com/topic/222481-counting-duplicate-rows-and-displaying-results/#findComment-1150710 Share on other sites More sharing options...
johny30238 Posted December 23, 2010 Author Share Posted December 23, 2010 This is what i am using in phpmyadmin: SELECT email, COUNT( * ) Count FROM table GROUP BY name HAVING COUNT( * ) >1 ORDER BY COUNT( * ) DESC LIMIT 0 , 10 Link to comment https://forums.phpfreaks.com/topic/222481-counting-duplicate-rows-and-displaying-results/#findComment-1150718 Share on other sites More sharing options...
johny30238 Posted December 23, 2010 Author Share Posted December 23, 2010 Does anyone have an solution for this? Link to comment https://forums.phpfreaks.com/topic/222481-counting-duplicate-rows-and-displaying-results/#findComment-1150918 Share on other sites More sharing options...
BlueSkyIS Posted December 23, 2010 Share Posted December 23, 2010 do you have any PHP code that you have tried? it would help if we could see it. If you don't know where to start, I suggest googling tutorials. http://www.google.com/search?client=safari&rls=en&q=php+mysql+tutorial&ie=UTF-8&oe=UTF-8 Link to comment https://forums.phpfreaks.com/topic/222481-counting-duplicate-rows-and-displaying-results/#findComment-1150933 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.