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)

Junior Member

5+ Year Member

joined:July 4, 2009
posts: 51
votes: 0

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 June 20, 2010 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Jan 29, 2002
votes: 1

"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 June 21, 2010 (gmt 0)

Junior Member

5+ Year Member

joined:July 4, 2009
votes: 0

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

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members