|
|
|
|
|
|
|
|
 |
|
|
|
|
<%if keyword<>"" or kind<>"" then%>
<%if keyword<>"" then
sql_count="select count(idx) from eyesearch where title like '%"&keyword&"%'"
set rs_count = db.execute(sql_count)
count1=rs_count(0)
rs_count.close
end if
if kind<>"" then
sql_count="select count(idx) from eyesearch where kind="&kind&""
set rs_count=db.execute(sql_count)
count1=rs_count(0)
rs_count.close
end if
%>
<%if keyword<>"" then%>
전체 : "<%=keyword%>"(으)로 검색하여 총 <%=count1%>개를 찾았습니다.
<%end if%>
<%if kind<>"" then%>
전체 : "<%=kind1%>" 계열에서 총 <%=count1%>개를 찾았습니다.
<%end if%>
<%
if keyword<>"" then
sql="select idx,title from eyesearch where title like '%"&keyword&"%' order by 2 asc"
end if
if kind<>"" then
sql="select idx,title from eyesearch where kind="&kind&" order by 2 asc"
end if
set rs = db.execute(sql)
if rs.bof or rs.eof then
%>
 검색된
자료가 없습니다
<%
else
do until rs.eof
idx=rs(0)
title=rs(1)
%>
<%
rs.movenext
loop
rs.close
end if
%>
|
<%end if%>
|
|
|
|
|
