<% notice_sql="select * from notice order by ans_group desc,ans_num asc" '모든 레코드 가져오기 set notic=server.createobject("adodb.recordset") '페이지 나누기 (레코드셋 열기전에 pagesize를 설정) '레코드 가져오기, 커서타입은 1로 notic.open notice_sql, db,1 do until notic.eof or i>3 title = getString(notic("title"),20) %>
  "><%=title%>
<%=Left(notic("writeday"),10)%>
<% i=i+1 notic.movenext loop %>







<% sql = "select top 4 * from GOODS where IMGS != '' order by UID desc" set rs=server.createobject("adodb.recordset") rs.open sql, db,1 do until rs.eof if rs("CATEGORY3") <> "" then CATEGORY3 = rs("CATEGORY3") End If If rs("CATEGORY1") = 1 then url = "sub3_7_1.asp" ElseIf rs("CATEGORY1") = 2 Then url = "sub3_4_1.asp" ElseIf rs("CATEGORY1") = 3 Then url = "" ElseIf rs("CATEGORY1") = 4 Then url = "sub3_3_1.asp" ElseIf rs("CATEGORY2") = 1 Then url = "sub3_1_1.asp?CATEGORY3=" & CATEGORY3 ElseIf rs("CATEGORY2") = 2 Then url = "sub3_1_2.asp?CATEGORY3=" & CATEGORY3 ElseIf rs("CATEGORY2") = 3 Then url = "sub3_1_3.asp?CATEGORY3=" & CATEGORY3 ElseIf rs("CATEGORY2") = 4 Then url = "sub3_1_4.asp?CATEGORY3=" & CATEGORY3 ElseIf rs("CATEGORY2") = 5 Then url = "sub3_1_5.asp?CATEGORY3=" & CATEGORY3 ElseIf rs("CATEGORY2") = 7 Then url = "sub3_1_6.asp?CATEGORY3=" & CATEGORY3 ElseIf rs("CATEGORY2") = 8 Then url = "sub3_1_7.asp?CATEGORY3=" & CATEGORY3 Else url = "sub3_2_1.asp?CATEGORY3=" & CATEGORY3 End if %> <% rs.movenext loop %>
" width="91" height="81" border="0">
<%=rs("G_NAME")%>