Udtræk af data.
Hej eksperter. I den følgende kode jeg poster kunne jeg godt tænke mig at få trækket det text som står i mit felt description ud fra databasen og lige ned under titlen på forumet:---------------------------------------------
<%
sub forum
ban()
response.write("<table width='540' border='0' align='center' cellpadding='0' cellspacing='0'>")
response.write("<tr>")
response.write("<td valign='top'>")
' foraoversigt
if getmode() = "normal" then
SQL = "SELECT id, title, description, locked FROM foras ORDER BY title"
set RS = conn.execute(SQL)
response.write("<table width='540' border='0' cellspacing='0' cellpadding='2'>")
response.write("<tr>")
response.write("<td width='195'><strong>Fora</strong></td>")
response.write("<td width='63' align='center'><strong>Tråde</strong></td>")
response.write("<td width='72' align='center'><strong>Svar</strong></td>")
response.write("<td width='194' align='center'><strong>Sidste tråd</strong></td>")
response.write("</tr>")
response.write("<tr>")
response.write("<td colspan='4' height='1' background='gfx/gif/dot.gif'></td>")
response.write("</tr>")
if RS.EOF then
response.write("<tr>")
response.write("<td colspan='4'>Ingen fora fundet!</td>")
response.write("</tr>")
else
do while not RS.EOF
SQL = "SELECT addeddate, addeddate, topic, id, author, memberid, email FROM foratopics WHERE fora = " & RS("id") & " ORDER BY id DESC limit 0,1;"
set RStopic = conn.execute(SQL)
if not RStopic.EOF then
topic = left(RStopic("topic"),30)
if session("login") = "" and RS("locked") = 2 then
topicstr = topic
else
topicstr = "<a href='?page=5&mode=replys&fora=" & RS("id") & "&topic=" & RStopic("id") & "'>" & topic & "</a>"
end if
email = RStopic("email")
author = RStopic("author")
end if
response.write("<tr>")
response.write("<td height='40'>")
if session("login") = "" AND RS("locked") = 2 then
title = RS("title")
else
title = "<a href='?page=5&mode=topics&fora=" & RS("id") & "'>" & RS("title") & "</a>"
end if
response.write(title)
response.write("</td>")
-------------------------------------------------
Hilsen
Gordy
