Hej!
Nar jag ska skriva ut inlagg och avsandare, antal inlagg osv sa maste jag(?!) kora med tva st loopar verkar det som. Men far inte ihop det.
rs("f_text") ar sjalva inlagget.
rs3..... ar med info om avsandare, "niva", inlagg...
sql satserna ser ut sa har:
set rs = Server.CreateObject("Adodb.Recordset")
If request.querystring("info") = "ja" then
sql = "select * from t_viktigt where ForumID = "& request.querystring("forumID") &" and svarID = "& request.querystring("svarID") &""
else
sql = "SELECT * from t_threads where ForumID = "& request.querystring("forumID") &" AND svarID = "& request.querystring("svarID") &""
end if
sql3 = "select t_threads.*, t_users.* from t_threads, t_users where t_users.username = t_threads.f_by AND t_threads.f_by = t_threads.f_user"
set rs3 = objConn.execute(sql3)
och sa har ser loopen ut och utskrivningen ut:
response.write "<table width=""600"" bgcolor=""#AFC2CF"" background=""meny/table_bar.gif"" cellspacing=""2"">"&_
"<tr><td width=""100""><font face=""Verdana"" size=""1"" color=""#FFFFFF""><b>Inskickad av:</b></font></td>" &_
"<td width=""600""><font face=""Verdana"" size=""1"" color=""#FFFFFF""><b>Inlägg:</b></font></td></tr></table>"
first = true
do while not rs.eof and intCurrentPost < rs.pagesize
if bgcolor = "#FFFFFF" then
bgcolor = "#f5f5f5"
else
bgcolor = "#FFFFFF"
end if
strContents = strContents
if first then
response.write "<table width=""600"" bgcolor="&bgcolor&" cellspacing=""2"">" &_
"<tr><td width=""100"" valign=""top""><font face=""Verdana"" size=""2"">"& rs3("f_by") &"</font></td><td width=""350""><a href=""#""><img src=""meny/profil.gif"" border=""0""></a><a href=""#""><img src=""meny/hemsida.gif"" border=""0""></a><a href=""#""><img src=""meny/email.gif"" border=""0""></a></td><td width=""100"" align=""right""><a href=""edit_post.asp?id="& rs3("threadID") &"""><img src=""meny/edit.gif"" border=""0""></a></td></tr><tr><td width=""100""><font face=""Verdana"" size=""1"">"& rs3("misc") &"<br>Inlagg: "& rs3("posts") &"</td>"
first = false
end if
if not isnull(rs("f_text")) then
response.write "<td width=""450""><font face=""Verdana"" size=""2"">"& fixa(rs("f_text")) &"</font></td>" &_
"</tr></table>"
intCurrentPost = intCurrentPost +1
rs.movenext
wend
liten julklapp! :e