Database, Tabel og ASP hjælp
Hej,Jeg har brug for lidt (meget) hjælp til en kode.
Jeg har en database med links i.
--- Kode start ---
<%
Set Conn = Server.CreateObject(\"ADODB.Connection\")
Conn.Open \"DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=\" & server.MapPath(\"db1.mdb\")
SQLstmt = \"SELECT * FROM Links ORDER BY Emne asc;\"
Conn.Execute (SQLstmt)
Set rs = conn.Execute(SQLstmt)
%>
<%
DO WHILE NOT rs.EOF
ID = rs(\"Id\")
Dato = rs(\"Dato\")
Navn = rs(\"Navn\")
Link = rs(\"Link\")
Emne = rs(\"Emne\")
Beskrivelse = rs(\"Beskrivelse\")
Beskrivelse = Replace(Beskrivelse,\".\",\".<br>\")
%>
<%
RS.MoveNext
Loop
RS.Close
conn.Close
Set conn = nothing
Set SQLstmt = nothing
%>
--- Kode slut ---
--- Tabel kode ---
<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"95%\" height=\"95%\">
<tr>
<td bgcolor=\"#000000\" height=\"1\" width=\"1\"><img border=\"0\" src=\"blank.gif\" width=\"1\" height=\"1\"></td>
<td bgcolor=\"#000000\" height=\"1\"><img border=\"0\" src=\"blank.gif\" width=\"1\" height=\"1\"></td>
<td bgcolor=\"#000000\" height=\"1\" width=\"1\"><img border=\"0\" src=\"blank.gif\" width=\"1\" height=\"1\"></td>
</tr>
<tr>
<td bgcolor=\"#000000\" height=\"15\" width=\"1\"><img border=\"0\" src=\"blank.gif\" width=\"1\" height=\"1\"></td>
<td bgcolor=\"#006699\" height=\"15\"><p align=\"center\"><font color=\"#FFFFFF\" size=\"2\" face=\"Verdana\">- Links-</font></p></td>
<td bgcolor=\"#000000\" height=\"15\" width=\"1\"><img border=\"0\" src=\"blank.gif\" width=\"1\" height=\"1\"></td>
</tr>
<tr>
<td bgcolor=\"#000000\" height=\"1\" width=\"1\"><img border=\"0\" src=\"blank.gif\" width=\"1\" height=\"1\"></td>
<td bgcolor=\"#000000\" height=\"1\"><img border=\"0\" src=\"blank.gif\" width=\"1\" height=\"1\"></td>
<td bgcolor=\"#000000\" height=\"1\" width=\"1\"><img border=\"0\" src=\"blank.gif\" width=\"1\" height=\"1\"></td>
</tr>
<tr>
<td bgcolor=\"#000000\" width=\"1\"><img border=\"0\" src=\"blank.gif\" width=\"1\" height=\"1\"></td>
<td bgcolor=\"#8098B0\"><p class=\"nyhed\">Her kommer linksene</td>
<td bgcolor=\"#000000\" width=\"1\"><img border=\"0\" src=\"blank.gif\" width=\"1\" height=\"1\"></td>
</tr>
<tr>
<td bgcolor=\"#000000\" height=\"1\" width=\"1\"><img border=\"0\" src=\"blank.gif\" width=\"1\" height=\"1\"></td>
<td bgcolor=\"#000000\" height=\"1\"><img border=\"0\" src=\"blank.gif\" width=\"1\" height=\"1\"></td>
<td bgcolor=\"#000000\" height=\"1\" width=\"1\"><img border=\"0\" src=\"blank.gif\" width=\"1\" height=\"1\"></td>
</tr>
</table>
--- Tabel kode slut ---
I denne tabel, der hvor der står \"Her kommer linksene\", skal alle mine links fra databasen, stilles op i tre lige lange kolonner, med omtrent lige mange links i hver.
Koden skal selv lave de tre lige store kolonner, da link antallet varierer.
Håber I kan hjælpe.
Zteven
