Top 5 list

[jacquesy]

I am bringing records from a database to my page using mysql_fetch_row() to display a top 5 list.

The problem is I want to print out the postion at the start of each line, i.e.
1. some-name
2. so ...

How would I do this?

[diego25]

Use a counter.

<?
$i = 1;
while ($row = ...) {
  print $i;
  print $row['field'];
  $i++;
}
?>

Diego

[Weedpacket]

Y'know, this is exactly the sort of syntax I've always wondered about; why is it so common? Literally from my first PHP programming experience I've written

$result=__query(...);
$numrows = __num_rows($result);
if($numrows)
{ for($i=0; $i<$numrows; $i++)
  { $row = __fetch_array($result);
    // Do stuff with $i and $row
  }
}
else
{ // No results, do something else.
}

And I've never understood why this isn't the norm. Could someone care to enlighten me, or is it just what I suspect: a spurious habit?

[diego25]

Maybe 'cause we're too lazy to change too much our copied-and-pasted while loop 😛

Diego

[jacquesy]

excellento, thank you guys!