Rank Results - MySQL

[papaface]

Hello,
Please help me :)
How would I go about displaying a 1,2,3,4 etc up to the total amount of results for the query?
Here is my code
[code]<?php

require ('includes/connect.php');

$grab = mysql_query("select * from submissions order by inbound desc ",$con) or die (mysql_error());

while ($row = mysql_fetch_array($grab))
{
echo '<a href="out.php?out='.$row['subid'].'">'. $row['sitename']. "</a>" . "<br>";
}
?>[/code]
I would like to rank the results therefore I need the first time it goes through the while loop to print a '1' next to the link.

Any ideas?

regards

[Destruction]

Before the while loop put
$count = 1;
Inside the loop use $count++ where you want the number displayed

Dest

[JJohnsenDK]

Yes or you could use a for loop.

[code]
<?php
$row = mysql_fetch_array($grap);
for($i = 1; $i > $row; $i++){
echo '<a href="out.php?out='.$row['subid'].'">'. $row['sitename']. "</a>" . "<br>";
}
[/code]

JJohnsenDK

[papaface]

Thanks :)