J
Jeff
Ok gang, I am going to try and explain my question.
I have a page where a person's position is listed. This is what I am using
to get that position.
I first sort by the round field in the DB, then I display the table on the
page. The problem I have is, if there are say 2 people with the same round
number, it continue's counting. For example
http://65.61.20.190/GIG/ladder/main.asp
see how the 4th and 5th place show the same number of laps )that is the
number in the round field in the DB), what I want is to show both of them
with a 4. here is my script:
<%
set admin1 = conn.execute ("SELECT * FROM rounds where round > 0 ORDER
BY round DESC,username ASC")
%>
<div align="center">
<center>
<table border="0" cellpadding="2" style="border-collapse: collapse"
width="27%" id="AutoNumber1">
<tr>
<td width="100%" colspan="3">
<p align="center"><b>GIG Ladder Lap Count</b></td>
</tr>
<tr>
<td width="50%" align="center" nowrap><b><font
size="4">Pos</font></b></td>
<td width="50%" align="center" nowrap><b><font
size="4">Name</font></b></td>
<td width="50%" align="center" nowrap><b><font
size="4">Laps</font></b></td>
</tr>
<%
game = 1
do while not admin1.eof
var1 = admin1.fields.item("round").value
var2 = admin1.fields.item("username").value
%>
<tr>
<td width="50%" align="center"><b><font size="4"
color="#C0C0C0"><%=game%></font></b></td>
<td width="50%" align="center"><b><font size="4"
color="#C0C0C0"><%=var2%></font></b></td>
<td width="50%" align="center"><b><font size="4"
color="#C0C0C0"><%=var1%></font></b></td>
</tr>
<%
game = game + 1
admin1.movenext
loop
%>
</table>
as you can see game is the position column in the displayed table.
How can I have it show the same pos for a number that is the same, but
continue counting as if they were NOT the same. Meaning, if there was a
person below them, they would be in 6th place, since 2 are tied for 4th?
I hope this makes sense
Please help
Bam
I have a page where a person's position is listed. This is what I am using
to get that position.
I first sort by the round field in the DB, then I display the table on the
page. The problem I have is, if there are say 2 people with the same round
number, it continue's counting. For example
http://65.61.20.190/GIG/ladder/main.asp
see how the 4th and 5th place show the same number of laps )that is the
number in the round field in the DB), what I want is to show both of them
with a 4. here is my script:
<%
set admin1 = conn.execute ("SELECT * FROM rounds where round > 0 ORDER
BY round DESC,username ASC")
%>
<div align="center">
<center>
<table border="0" cellpadding="2" style="border-collapse: collapse"
width="27%" id="AutoNumber1">
<tr>
<td width="100%" colspan="3">
<p align="center"><b>GIG Ladder Lap Count</b></td>
</tr>
<tr>
<td width="50%" align="center" nowrap><b><font
size="4">Pos</font></b></td>
<td width="50%" align="center" nowrap><b><font
size="4">Name</font></b></td>
<td width="50%" align="center" nowrap><b><font
size="4">Laps</font></b></td>
</tr>
<%
game = 1
do while not admin1.eof
var1 = admin1.fields.item("round").value
var2 = admin1.fields.item("username").value
%>
<tr>
<td width="50%" align="center"><b><font size="4"
color="#C0C0C0"><%=game%></font></b></td>
<td width="50%" align="center"><b><font size="4"
color="#C0C0C0"><%=var2%></font></b></td>
<td width="50%" align="center"><b><font size="4"
color="#C0C0C0"><%=var1%></font></b></td>
</tr>
<%
game = game + 1
admin1.movenext
loop
%>
</table>
as you can see game is the position column in the displayed table.
How can I have it show the same pos for a number that is the same, but
continue counting as if they were NOT the same. Meaning, if there was a
person below them, they would be in 6th place, since 2 are tied for 4th?
I hope this makes sense
Please help
Bam