You need to increment a variable!
Assuming your code looks somewhat like this...
Code:
Do While Not rs.eof
response.write "<tr><td>" & rs("firstname") & "</td><td>" & rs("lastname") & "</td></tr>"
rs.MoveNext
Loop
...you'll want to increment a counter within the loop like this:
Code:
Do While Not rs.eof
iRowCounter = iRowCounter + 1
response.write "<tr><td>" & iRowCounter & "</td><td>" & rs("firstname") & "</td><td>" & rs("lastname") & "</td></tr>"
rs.MoveNext
Loop
HTH
~Jonax