List items from MySQL and rank

[timmah1]

I have a statement that selects everything from the database and lists them in order of money from highest to lowest.

 

How do I put the rank (numbers, 1, 2, 3,..) next to the information?

I tried using

<ol><li>

but that just puts a 1. beside everyone.

 

thanks in advance

[craygo]

use a counter

$i=1;
while($r=mysql_fetch_assoc($result)){
echo $i." ".$r['field1']."<br />\n";
$i++;
}

 

Ray