php - Delete repeated results from MySQL query -


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 show in php page just:

totalpoints --  name  55 -- john doe 21 -- jean london 13 -- mark derry 4 -- lara croft 1 -- ryan mirtle 

how can rid off repeated results? lot

what using distinct? seems pretty easy... tried google it? ou have found in no time.


Comments