
August 30th, 2006, 04:32 PM
|
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
|