Pladsnummer foran ranglisten

<html>
<head>
    <title></title>
</head>
<body>

<%
    Set objConn = Server.CreateObject("ADODB.Connection")
    objConn.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.Mappath("db/db.mdb")
   
    strSQL = "SELECT * FROM clans ORDER BY won DESC, lost ASC"
    Set objRs = objConn.Execute(strSQL)   
%>
<table>
    <tr>
        <td><b>No</b></td>
        <td><b>Clan</b></td>
        <td><b>Won</b></td>
        <td><b>Lost</b></td>
    </tr>

<%
i = 0
    While Not objRs.EOF   
    i = i + 1 
      Response.Write("<tr>")
            Response.Write("<td>" & i & "</td>")
            Response.Write("<td>" & objRs("clanname_long") & "</td>")
            Response.Write("<td>" & objRs("Won") & "</td>")
            Response.Write("<td>" & objRs("Lost") & "</td>")
        Response.Write("</tr>")
    objRs.MoveNext()
    Wend
%>
</table>

</body>
</html>

//>Rune

over dit While Not objRs.EOF skriver du strNr = "0"

under dit While Not objRs.EOF skriver strNr = strNr + 1

og så udenfor navnet skriver du <%=strNr%>

aspbuilder> LOL så bliver det da heller ik' mere præcist!

Accepteret svar: medions
Point : 15
04/01-2003 21:23:19

vist svar: aspbuilder
04/01-2003 21:23:19

På sekundet ;o)


Thx 4 Poinz

//>Rune