SoloHouse獨奏家音樂學習網__________________________________________________________________SoloHouse獨奏家___________________________________________________________________________________________________________________________

文章/演出者:

建安

<% SQL="select * from sh_bulletin where bulletin_board=1 and bulletin_startcdate('" & SQLDateTime(now) & "') order by bulletin_posttime desc" 'response.write SQL 'response.end set rs1=GetRS(SQL,conn) do until rs1.eof %> <% rs1.movenext loop %>

<%select case rs1("bulletin_type") case "1" %> ')" class="forumlink2">

<%=rs1("bulletin_subject")%>

<% case "2" %> " class="forumlink2">

<%=rs1("bulletin_subject")%>

<% case "3" %> " target="_blank" class="forumlink2">

<%=rs1("bulletin_subject")%>

<%end select%>

<% SQL="select top 3 * from (select top 3 f.forum_name,t.forum_id,t.topic_id,t.topic_title,u.user_name,u.user_id from sh_topics t, sh_categories c, sh_forums f, sh_users u where t.forum_id=f.forum_id and f.cat_id=c.cat_id and t.topic_poster=u.user_id order by t.topic_time desc) X" set rs1=GetRS(SQL,conn) i=0 do until rs1.eof i=i+1 if (i/2)=int(i/2) then cc="row1" else cc="row2" %> <% rs1.movenext loop %>

最新訊息看板狀態
類別	主題	名稱
<%=rs1("forum_name")%>	" class="forumlink2"><%=rs1("topic_title")%>	<%=rs1("user_name")%>

<% SQL="select top 3 * from (select top 3 f.forum_name,t.forum_id,t.topic_id,t.topic_title,u.username,u.user_id,u.user_name from sh_topics t, sh_categories c, sh_forums f, sh_users u where t.forum_id=f.forum_id and f.cat_id=c.cat_id and t.topic_poster=u.user_id order by t.topic_replies desc) X" set rs1=GetRS(SQL,conn) i=0 do until rs1.eof i=i+1 if (i/2)=int(i/2) then cc="row2" else cc="row1" %> <% rs1.movenext loop %>

熱門回應訊息看板
類別	主題	名稱
<%=rs1("forum_name")%>	" class="forumlink2"><%=rs1("topic_title")%>	<%=rs1("user_name")%>

看板