meget lille asp opgave

jeg kan da godt lave det...

navn på database - type (access, mysql) - navn på tabeller - navn på kolonner

<%

set conn = Server.CreateObject(\"ADODB.Connection\")
conn.Open \"Driver={Microsoft Access Driver (*.mdb)}; DBQ=\" & Server.MapPath(\"xxx.mdb\")
SQL = \"SELECT COUNT(id) as found FROM users\"
Set RS = Conn.Execute(SQL)

    Response.Write \"Der er ialt \" & rs(\"found\") & \" tilmeldte</a>\"
   
rs.Close
Set rs = Nothing

%>

------------------------------------

<%

set conn = Server.CreateObject(\"ADODB.Connection\")
conn.Open \"Driver={Microsoft Access Driver (*.mdb)}; DBQ=\" & Server.MapPath(\"xxx.mdb\")
SQL = \"SELECT top 10 * FROM users ORDER BY id desc\"
Set RS = Conn.Execute(SQL)

If Not (rs.BOF Or rs.EOF) Then
    Do While Not rs.EOF
   
    Response.Write \"\" & rs(\"name\") & \" (\" & rs(\"id\") & \")<br />\"
   
    rs.movenext
    loop

else

    Response.Write \"ingen poster fundet\"
   
end if
   
rs.Close
Set rs = Nothing

%>

heh. lette 200 point (: