Hi Webmasters,
I am using a poll from which I can get the poll results from my Access Db properyl by the following code:
<td width="100%">
<%DO UNTIL rsAnswer.EOF%>
<%percent = FormatPercent(rsAnswer("total_votes")/rsPoll("total_votes"),0)%>
<table width="100%" cellspacing="0" height="15">
<tr>
<td width="350" style="width: 125" class="style1" size="10px">
<%=rsAnswer("total_votes")%><span class="style2">Vote(s)</span> </td>
<td width="350" style="width: 200" class="style4">
<img src="votes.gif" width="<%=percent%>" height="20" class="style5">
</td>
<td Align="right" class="style3" style="width: 125">
<strong> <%=rsAnswer("answer")%></strong>
</td>
</tr>
</table>
<%rsAnswer.MoveNext%>
<%LOOP%>
</td>
The code represents the results of the votes and also the total number of votes for each question. (variable total_votes)
It works properly but what I am trying to achieve is to sort the results by the variable (total_votes) descending. I mean that the most voted question or result lies at the top and continues with the next most voted question in the next line.
have been trying to sort it out with (ORDER BY total_votes ASC) at the end of %LOOP% but it did not work.
Any comments about the correct usage of the code is appreciated.
Thank you for your time & comments.
