[James Talbot]

Its quite easy an easy way to do what i think you want.

PHP Code:

$sql = mysql_query("SELECT * FROM table ORDER BY something");



// Set rank to 0



$rank = 0;



while($data = mysql_fetch_array($sql)) {





$rank = $rank++;



?>



<p><?=$rank;?></p>

<p><?=$data['username'];?></p>



<?

}

?>

Obviously update that so it suits your needs.