5 nyeste tilføjelser!

SELECT * FROM script order by id Limit 5

Således tager den kun de nedeste, fem, i tablen script

sql = \"select top 5 * from din_tabel\"

<%
set Conn = Server.CreateObject(\"ADODB.Connection\")
Conn.Open \"Driver={Microsoft Access Driver (*.mdb)}; DBQ=\" & Server.MapPath(\"database.mdb\")

SQL = \"SELECT TOP 5 * FROM tabel\"
set rs = Conn.execute(SQL)
Do Until rs.EOF
%>

<%=rs(\"felt\")

<%
rs.MoveNext
Loop
%

Tjekker lige engang

<%
set Conn = Server.CreateObject(\"ADODB.Connection\")
Conn.Open \"Driver={Microsoft Access Driver (*.mdb)}; DBQ=\" & Server.MapPath(\"database.mdb\")

SQL = \"SELECT TOP 5 * FROM tabel\"
set rs = Conn.execute(SQL)
Do Until rs.EOF
%>

<%=rs(\"felt\")%>

<%
rs.MoveNext
Loop
%

<%
set Conn = Server.CreateObject(\"ADODB.Connection\")
Conn.Open \"Driver={Microsoft Access Driver (*.mdb)}; DBQ=\" & Server.MapPath(\"database.mdb\")

SQL = \"SELECT TOP 5 * FROM tabel\"
set rs = Conn.execute(SQL)
Do Until rs.EOF
%>

<%=rs(\"felt\")%>

<%
rs.MoveNext
Loop
%>

Har prøvet alle script! Men den tager de 5 laveste ID\'er! Jeg skal bruge de 5 højeste ID! Den inkludere ikke den nyeste, men bare top 5 som er de 5 laveste ID

/Thomas

<%
set Conn = Server.CreateObject(\"ADODB.Connection\")
Conn.Open \"Driver={Microsoft Access Driver (*.mdb)}; DBQ=\" & Server.MapPath(\"database.mdb\")

SQL = \"SELECT TOP 5 * FROM tabel ORDER BY ID DESC\"
set rs = Conn.execute(SQL)
Do Until rs.EOF
%>

<%=rs(\"felt\")%>

<%
rs.MoveNext
Loop
%>

<%
set Conn = Server.CreateObject(\"ADODB.Connection\")
Conn.Open \"Driver={Microsoft Access Driver (*.mdb)}; DBQ=\" & Server.MapPath(\"database.mdb\")

SQL = \"SELECT TOP 5 * FROM tabel order by id asc\"
set rs = Conn.execute(SQL)
Do Until rs.EOF
%>

<%=rs(\"felt\")%>

<%
rs.MoveNext
Loop
%>

ups desc ;-P

Både Bjarke-B og tpill fik hver 10 point! Tak for hjælpen!