A MySQL query retrieves:
totalpoints -- name
55 -- John Doe
55 -- John Doe
55 -- John Doe
55 -- John Doe
55 -- John Doe
21 -- Jean London
21 -- Jean London
13 -- Mark Derry
13 -- Mark Derry
13 -- Mark Derry
13 -- Mark Derry
4 -- Lara Croft
1 -- Ryan Mirtle
1 -- Ryan Mirtle
1 -- Ryan Mirtle
I need to show in a php page just:
totalpoints -- name
55 -- John Doe
21 -- Jean London
13 -- Mark Derry
4 -- Lara Croft
1 -- Ryan Mirtle
How can I get rid off the repeated results? Thanks a lot
What about using DISTINCT? Seems pretty easy... But you actually tried to google it? ou would have found it in no time.
select name,totalpoints
from table
group by name
order by totalpoints desc
select distinct name,totalpoints from table
Very easy. use following query:
SELECT totalpoints, name
FROM table_name
GROUP BY name
ORDER BY totalpoints DESC
Please use DISTINCT keyword in your query to avoid duplicate entries