Added: January/26/2006 at 7:26am | IP Logged

I am trying to connect to an access database to display comments sent from users of my site to other users.
i have set varProfileUSER as a variable for the user I want to display the comments for.
The file below is what I have been using, but I want to display newer messages first rather than older ones first, and for this I need to read from the database backwards (or so it would seem)
Is there any way to do this?
This is the script I have so far:
<%
set Conn = server.createobject("ADODB.Connection")
Conn.Open "DRIVER=Microsoft Access Driver (*.mdb);PWD=DBPassword;DBQ="&Server.MapPath("usercomment s.mdb")
set rs=Conn.execute ("Select * From comments")
while not rs.eof
if rs("towho") = varProfileUSER then
response.write("<tr><td width='25%' border='0'>"& rs("fromwho")&"<br>"& rs("time") &" "& rs("date") &"</td><td width='75%' border='0'>"& rs("comment") &"</td></tr>")
end if
rs.movenext
wend
Conn.close
Conn=null
%>

Any help is greatly appreciated
Thanks in advance

Added: May/27/2006 at 8:08am | IP Logged

simple, just use the ORDER BY

the code shoudl be like this

set rs=Conn.execute ("Select * From comments ORDER BY date ASC")

if it still gets the same output then change it into this

set rs=Conn.execute ("Select * From comments ORDER BY date DESC")

this way it is sorting the comments by date Accesnding (ASC) or Desccending (DESC)
but if you want to be sorted by other field then simply take out the field date and insert other like time...

Hope this helps

Best Regards