help in this asp ms sql problem

hi all, i cant solve the problem and it is quite urgent. i hope u can give me a hand.
i need to do a search. but this search is quite complicated for me since i m newbie here. i m using ms sql with asp script. from my interface, there is one text box for user insert keywords search, and two checkbox for users to check wan search by photographer name or lightbox. by default, it will search the keywords with the photoname and also the photokeywords. when user check the photographer checkbox, it will also search the photographer keywords at the same time; if user check the ligthbox, it will search the photoname, photokeywords and also the lightbox keywords, see if got the lightbox match, then check inside the lightbox got any photo, if got, get the result. if user check both then will search both of the condition. my output will be the photoname, photohrapher name, if the photo is inside the lightbox, then will display the lightbox name also. i duno how to do a good searching that can reduce the searching speed in Db. plz help...
below is my table design. i hope u can help me..thank you.

tbl_photo (photoid, photoname,photokeywords)
tbl_lightbox (lightboxid,lightboxname, lightboxkeywords)
tbl_lightboxphoto(lightboxphotoid,lightboxid,photoid)
p/s : the photokeywors, lightboxkeywords are store in this way --> apple orange pear grapes (with a space between the words)

Hi,



First of all you need to use Get in form tags when you Get the data from asp page give the case else command there for example
strOp1 = Request.QueryString("CBox1")
strOp2 = Request.QueryString("CBox2")

If strOp1 = True Then
'Your search sql query comes here
Else
'Your second sql query comes here
End If

Rsobj.open sqlQ, ObjConn,1,1
Numbering = 10 ' records per page
Count = 0 'counts the records
Do while not Rsobj.eof or Rsobj.Bof and Count < Numbering
'your recordsets here and some html
Rsobj.moveNext
Count = Count +1
Loop





Thats all