<%

if request.form("btnSubmit")<>"" then
Dim  selCrit,arrSearch

    if request.form("strsearch") <>"" then
          Call Keywrd(strSQL)
    end if

    set rs = Server.CreateObject("ADODB.RecordSet")    

    Sub Keywrd(strSQL)
             selCrit = "Or"
             chk_photographer= request.Form("photographer")
             strInput= request.form("strsearch")
             strInput=Replace(strInput,","," ")
             //remove extraneous spaces in a string
             Do While InStr(1, strInput, "  ")
                strInput = Replace(strInput, "  ", " ")
             Loop
             response.Write strInput &"<BR>"

             // use split to break it down into an array
             arrSearch = split(strInput," ")
             strName = join(arrSearch, "%') " & selCrit & " (photoname LIKE '%") 
                     strCombine =  join(arrSearch, "%') " & selCrit & " (photokeywords LIKE '%") 
                     strphotographer= join(arrSearch, "%') " & selCrit & " (photographer LIKE '%") 
                     strlightbox= join(arrSearch, "%') " & selCrit & " (keywords LIKE '%") 

               strSQL = "SELECT * FROM tblp_photo"


                    strSQL = strSQL & "  WHERE(photokeywords LIKE '%" & strCombine & "%')"
                    strSQL = strSQL & " OR(photoname LIKE  '%" & strName  & "%')"
                    if request.Form("photographer")= "chkPhoto" then
                       strSQL = strSQL & " OR(photographer LIKE  '%" &  strphotographer & "%')"
                   end if
    End Sub

        rs.Open strSQL,objConn
        If not Rs.EOF Then
            Do While Not Rs.EOF
                response.Write rs("photoname")  &"<BR>"
                response.Write rs("photoid")
            rs.MoveNext
            loop
        end if
                response.write strSQL &"<BR><BR>"
end if

%>
<form name="frm" action="test4.asp" method="post">
<input type="text" name="strsearch" <%if request.form("strsearch")<>"" then  response.write request.form("strsearch") end if %> />
<br />
<input type="checkbox" value="chkPhoto" name="photographer" />
Photographers Name <br />
<input type="checkbox" value="chkLightBox" name="lightbox" />
Lightbox <br />
<input type="submit" name="btnsubmit" value="Submit" />
</form>
</body>
</html>