php - Echoing out a field and a value from one row while running a query that ranks all rows

Question

I have a MySQL query called $sqlStr5 that ranks rows by a metric called totalScore2. One of the fields that $sqlStr5 returns is called username.

I would like to echo out the rank and the value of totalScore2 where username equals a variable called $u.

How can I do this?

Below is what I have so far.

Thanks in advance,

John

$result = mysql_query($sqlStr5);
$count = 1;  
$arr = array();

    while ($row = mysql_fetch_array($result)) { 

            echo '<div class="sitename1edit2a">'.$count++.'.</div>';
            echo '<div class="sitename1edit2">'.number_format(($row["totalScore2"])).'</div>';


        }

Answer 1

This should work:

$result = mysql_query($sqlStr5);
$count = 1;

while($row = mysql_fetch_array($result))
{
    if($u == $row['username'])
    {
        echo '<div class="sitename1edit2a">'.$count.'</div>';
        echo '<div class="sitename1edit2">'.number_format($row["totalScore2"]).'</div>';
    }
    $count++;
}

Note however that this is not the most efficient way. It should be possible to make a SQL query that returns the rank and the total score for user $u.