How to do this in SQL and php?

See more:

SQL

PHP

Hello people,

i am stuck with this, please help me, how to do this.

i have a sql table, with fields,

name, username, score,

the table contains, data like this,

user1 username1 5
user2 username2 10
user1 username1 2
user2 username2 1

Now, i need a php and sql script to show a sorted table,with a user should appear only once with their highscores.

Like,

user2 username2 10
user1 username 5

Your help is verymuch needed, thank you!