Fatter det bare ik??
Hvorfor viser den ik kun 100 her???<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath ("../tacmail/database.mdb")
strsql = "SELECT top 100 * from users ORDER BY len(tid) DESC"
set rs = Conn.execute(strSQL)
if rs.eof Then
else
Do Until RS.EOF
%>
<tr>
<td width="33%"><font size="2" face="Verdena, Tahoma, Arial"> <A href="#" onclick="window.open('http://www.adichat.dk/adichat/se_user.asp?id=<%=rs("id")%>','users','WIDTH=300,HEIGHT=340,scrollbars=yes')"><%=rs("username")%></a></font></td>
<td width="33%"><font size="2" face="Verdena, Tahoma, Arial"> <%=rs("tid")%></font></td>
</tr>
<%
RS.MoveNext
Loop
end if
rs.close
set rs = nothing
conn.close
set conn = nothing
%>
