Top ten script

Dev Articles Community Forums Sponsor:

August 30th, 2006, 05:32 PM

mpempe

Registered User

Join Date: Aug 2006

Posts: 3

Time spent in forums: 25 m 36 sec
Reputation Power: 0

Top ten script

Ihave write a script to present in my page the ten songs with the best voting
Is all ok
This is my code who present the 10 best voting sonks

Code:

<table border="1" size="640">
<tr>
  <td width="80">  No </td>
  <td width="200"> Title</td>
  <td width="200">Song</td>
  <td width="80" > Vote</td>
  <td idth="80" >Vote Level</td>
</tr>
<%
sqlString = "SELECT TOP 10 votes_id, votes_title, votes_date, votes_artist, votes_number, votes_level FROM votes " &_
  "ORDER BY votes_level DESC"
SET RS = Con.Execute( sqlString )
DIM iRecordCount
iRecordCount = 0
'οι εγγραφές που θα εμφανίζονται
DO WHILE NOT RS.EOF and iRecordCount <> 10

%>
<tr>
    <td>1</td>
    <td ><%=RS( "votes_title" )%></td>
    <td ><%=RS( "votes_artist" )%></td>
    <td ><a href="?renewal=1&productID=<%=RS("votes_id")%>" onclick="return confirmRenewal(<%=RS("votes_number")%>)">Ψήφος</a></td>
    <td ><%=RS("votes_level")%></td>

<%
iRecordCount = iRecordCount + 1
RS.MoveNext
Loop

RS.Close
Set RS = Nothing
Con.Close
Set Con = Nothing
%>

My problem is i cant make the first calumn to display the numbers 1, 2, 3, 4, 5, 6, 7, 8, 9, 10
The numbers have to constant

is it possible?

Sorry for my bad english

August 31st, 2006, 09:00 AM

MadCowDzz

I'm Internet Famous

Dev Articles Frequenter (2500 - 2999 posts)

Join Date: Jan 2003

Location: Toronto, Canada

Posts: 2,886

Time spent in forums: 1 Week 16 h 19 m 35 sec
Reputation Power: 19

Instead of this:
<td>1</td>

Try this:
<td><%= (recordCount+1) %></td>

I also advise changing the DO statement to this:
DO WHILE NOT RS.EOF and iRecordCount < 10

No real reason, it just feels better =)

__________________
Daryl's Homepage | My Blogroll | My Profile | Firefox supporter!
DevArticles Forum Moderator

"The net is a waste of time, and that's exactly what's right about it." -- William Gibson