HELP. Position in row query

[Bakbai]

what i need is how to sum two or more columns with mysql and let php determine the the highest and lowest, by given it sum a position.
here is my code which i earlier tried.

Select sum(score1+score2) from whatever table
 
$x=0
while($row = mysql_fetch_array($result) {
if ($user == $row['user']) {
echo "$user is rank $x out of " . count($result);
break;
} else {
$x++
}
}
 
 

but i am not getting desired result. need help

[code green]

I believe this is a piece of sudo-code supplied by your tutor as a basis to produce an assignment.

here is my code which i earlier tried

You need to try harder

[Markus]

Bakbai, please read the Posting Guidelines on Homework.

Markus.