Pantho Posted June 5, 2010 Share Posted June 5, 2010 Forgive me but my knowledge on MySQL queries is not exactly grand. I have a database with around 10000 rows, but there are duplicates to some of these rows. Sometimes 1 or 2, sometimes 5 or 6 duplicates. My Top100 page looks a mess having 1 person take up 5 ranks, I need to remove duplicate values. Image to show what I mean: http://i50.tinypic.com/fkme5j.png Quote Link to comment https://forums.phpfreaks.com/topic/203992-help-deleting-duplicate-rows/ Share on other sites More sharing options...
fenway Posted June 5, 2010 Share Posted June 5, 2010 What query is pulling back these duplicates? Or are there actually duplicates in the recordset? Quote Link to comment https://forums.phpfreaks.com/topic/203992-help-deleting-duplicate-rows/#findComment-1068423 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.