Numbered List of results

[medar]

I am trying to get my list to display the number of rows...IE:

1. Result one
2. Result two
3. Result three

Here is my code:

$result = mysql_query("SELECT * FROM $userstable ORDER BY da_lastweek DESC");
if ($myrow = mysql_fetch_array($result)) {

  // display list if there are records to display

echo "<table border=1><tr><td><B>Name</B></td><td><B>Class</B></td><td><B>Last Week</B></td></tr>";

  do {printf("<tr><td valign=top>%s</td><td valign=top>%s</td><td valign=top>%s</td></tr>\n", $myrow["da_name"], $myrow["da_class"], $myrow["da_lastweek"]);

  } while ($myrow = mysql_fetch_array($result));

echo "</table><P>";

}

Any idea how I could insert a NUMBER in front of each name in there?

[wizkid]

Hi,

try following:

$result = mysql_query("SELECT * FROM $userstable ORDER BY da_lastweek DESC"); 
$i = 1;
if ($myrow = mysql_fetch_array($result)) { 
  // display list if there are records to display 
  echo "<table border=1><tr><td><B>Name</B></td><td><B>Class</B></td><td><B>Last Week</B></td></tr>"; 
  do {
    printf("<tr><td valign=top>%s. %s</td><td valign=top>%s</td><td valign=top>%s</td></tr>\n", $i, $myrow["da_name"], $myrow["da_class"], $myrow["da_lastweek"]); 
    $i++;
  } while ($myrow = mysql_fetch_array($result)); 
  echo "</table><P>"; 
} 

I hope it works, because I didn't test it. :o

wizkid