Problem with array data

[alexhard]

I extract data from a mysql database. this data is:
username and score
i want to sort the score but if i sort it, it will correspond to different usernames.
How can i sort the score and keep the usernames to their representing score?
thanks in advance

[YappyDog]

Why not just use an ORDER BY clause in your sql statement like:

$sql = "Select username, score from myTable order by score desc";

[alexhard]

thanks, that worked perfectly!
one more thing tho
how can i find a usernames position?
so that i can fisplay the rank of a person.
my current code is:

$query="SELECT * FROM users ORDER BY score DESC LIMIT 10";
$result=mysql_query($query, $link) or die("Error with Database ".mysql_error());
$p=1;
while ($a_row = mysql_fetch_array( $result ) ) {
print("<tr>");
print("<td>".$p."</td><td>".$row1['username']."</td><td>".$row1['Score']."</td>");
print("<tr>");
$p++;
}

how can i enter the rank of player X into a varible? i need to do this on other pages too and it would be great if i didnt have to execute this code on every page.
thanks in advance