|
|
|
|
 |
|
혜림 / 2001-03-27 / 오후 8:24:40 / 211.61.27.229
조회수 : 150
|
| [질문] 안보면 미워할꼬야!~~~yl |
두가지 검색조건을 만족 시키는 검색 결과를 얻고 싶은데,
지가 워낙의 허접이라 힘들군여,,,
고수님들 도와주세요...ㅠ.ㅠ
*************** search.asp
<select name="search">
<option value="name">이름별루.</option>
<option value="content">직업별루</option>
</select>
<select name="search1">
<option value="adr">장혁 </option>
<option value="adr">우성</option>
<option value="adr">지현</option>
<option value="adr">동건</option>
</select>
<input type="text" name="SearchString">
*************search_result.asp
<%
search = request("search")
search1= request("search1")
SearchString =request("SearchString")
Set db = Server.CreateObject("ADODB.Connection")
db.Open("MySiteDB")
' if search = "content" and search1 = "adr" then
' SQL = "SELECT * FROM MyBoard2 where content and adr like '%"
& SearchString & "%' "
' SQL = SQL & " ORDER BY num DESC"
' elseif search ="name" and search1 = "adr" then
' SQL = "SELECT * FROM MyBoard2 where name and adr like '%" &
SearchString & "%' "
' SQL = SQL & " ORDER BY num DESC"
' end if
SQL = "SELECT * FROM MyBoard2 where " & search & " + " &
search1 & " like '%" & SearchString & "%' "
SQL = SQL & " ORDER BY num DESC"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open SQL,db,1
%>
대략 이렇거든여...
잘못된줄 알지만 어딜 어떻게 수정해야 할지 모르겟어여
고수님덜 꼭 부탁드립니다...
|
|
|
|