PHP echos table. How to automatically number rows?

[JsteRmX]

[resolved] PHP echos table. How to automatically number rows?

So I pulled some data from a mysql database and have it echoed into an html table. How can i make the HTML table automatically number the rows? I want the row #s to be independent from the mysql data so that i can sort by different variables.

Here is the code:

echo "<table border='0' p class ='style15' align='left'>
<tr>
<th>Student Name</th>
<th>Speech Title</th>
</tr>";

while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo "<td>" . $row['name'] . "</td>";
  echo "<td>" . $row['speech'] . "</td>";
  echo "</tr>";
  }
echo "</table>";

help is appreciated. Thank yoU!!

 

[RegFee]

echo "<table border='0' p class ='style15' align='left'>
<tr>
<th>ID</th>
<th>Student Name</th>
<th>Speech Title</th>
</tr>";

//set counter variable
$counter = 1;

while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo "<td>" . $counter . "</td>";
  echo "<td>" . $row['name'] . "</td>";
  echo "<td>" . $row['speech'] . "</td>";
  echo "</tr>";
  $counter++; //increment counter by 1 on every pass
  }
echo "</table>";

 

[JsteRmX]

sweet! thank you. that was simple, eh? rep+

 

[Jens jacob schmidt]

hey still works .. : )