城隍廟-台中市晉封威靈公都城隍廟::管理後台

<%If (Session("user") <> "") Then%> <%else%> <%End if%>

祭典活動

留言板

會員管理

最新消息

報名項目

後台管理系統，請先登入

留言板

<% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open Server.MapPath("/database/SingingBusDB.mdb") set rs=Server.CreateObject("ADODB.recordset") strSQL="SELECT *, (SELECT nick FROM member WHERE member.id = guestbook.member) as member FROM guestbook order by datepost desc" rs.Open strSQL,conn Do While Not rs.Eof Response.write "" Response.write "" Response.write "" Response.write "" Response.write "" Response.write "" Response.write "" Response.write "" rs.movenext Loop rs.close conn.close Set conn = Nothing Set rs = nothing %>


張貼日期	發問人	標題	點閱數	回覆	刪除
" & rs("datepost") & "	" & rs("nick") & "	" & rs("subject") & "	" & rs("counts") & "	" If rs("reply") <> "" Then response.write "已回覆" Else response.write "未回覆" End if Response.write "