Numbering Table Rows

[geosite]

Imagine a database table that features information on various geographic units, including oceans (oce), continents (con), nations (nat) and dependencies (dep). Suppose I display a table that lists only nations, ranked in order of size (geographic area), with Russia first.

Is there a way to insert numerals to indicate each nation's rank? In other words, the table would look like this...

1. Russia
2. Canada

I might insert the numerals in a separate table column, or I might just insert them in the column holding the nations' names.

Is there a PHP function that sequentially numbers table rows?

Thanks.

[hash]

Use a counter?

$i = 1;
foreach($countries as $v) {
    echo $i;
    echo $v;
    $i++
} 

[cranial-bore]

$nat = array('Russia', 'Canada', 'New Zealand', 'Monaco', 'Singapore');
$count=0;
foreach($nat as $n) {
   $count++;
   echo "<tr>
       <td>$count</td>
       <td>$nat</td>
   </tr>\n";
} 

You're probably looping over a database result set. Just increment and echo a variable as shown.

[geosite]

Thanks for the tips. That'll beat adding extra numerical fields in my database table.