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. Quote Link to comment 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 Quote Link to comment 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 Quote Link to comment 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? Quote Link to comment 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 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.