Welcome to WebmasterWorld Guest from

Forum Moderators: ocean10000

Message Too Old, No Replies

ORDER BY field name ASC (sorting Access DB results)



11:20 am on Jun 20, 2010 (gmt 0)

5+ Year Member

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">
<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 Align="right" class="style3" style="width: 125">
<strong> <%=rsAnswer("answer")%></strong>

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.


11:52 am on Jun 20, 2010 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member

"ORDER BY total_votes ASC" needs to be in your SQL statement, i.e. the database query used to open rsAnswer. HTH


6:14 pm on Jun 21, 2010 (gmt 0)

5+ Year Member

Have done it so, works great!
Thank you very much mattur.

Featured Threads

Hot Threads This Week

Hot Threads This Month