add a numbered column to SQL results?

[newb]

I have an SQL query:

SELECT username, dl_sumtotal

FROM `vb_user`

ORDER BY dl_sumtotal DESC

LIMIT 0 , 30

Right now, its results display like this:

 

username3: 500

username1: 400

username2: 300

 

How can I give these results a numbered column so it displays like this:

 

 

1: username3: 500

2: username1: 400

3: username2: 300

 

I would like to output that number in my PHP script. thanks for any help.

[wildteen88]

I assume you mean on your webpage. You can use an ordered list

$result = mysql_query($query);

echo "<ol>";
while(list($username, $dl_sumtotal) = mysql_fetch_row($result))
{
     echo "<li>$username: $dl_sumtotal</li>";
}
echo "</ol>";

[newb]

nvmd i figured it out thanks anyway

 

SELECT username, dl_sumtotal, @curRow := @curRow +1 AS row_number
FROM `vb_user`
JOIN (

SELECT @curRow :=0
)r
ORDER BY dl_sumtotal DESC
LIMIT 0 , 30

[newb]

scratch that.

 

this works alot better than the above query used:

	$query = mysql_query("SELECT userid,username,
       dl_sumtotal,
       rank
  FROM (SELECT userid,username,
               dl_sumtotal,
               @rownum := @rownum + 1 AS rank
          FROM vb_user
          JOIN (SELECT @rownum := 0) r
      ORDER BY dl_sumtotal DESC) x
WHERE userid = $uid");