kumiko
-
Total Posts
:
2
- Scores: 0
-
Reward points
:
0
- Joined: 4/2/2008
-
Status: offline
|
Problem in searching multiple keywords(database)
Wednesday, April 02, 2008 9:12 PM
( permalink)
 04-03-2008, 04:10 AM
kumiko 
vbmenu_register("postmenu_13694", true);
Registered User
Join Date: Jul 2006
Posts: 1
 Problem in searching multiple keywords match with multiple field in database
hi, good day.
i have some problem in doing the searching multiple keywords function.
in my layout i have a textbox,user can insert many keywords with the comma separator between each keywords. and then the search function will go to search 3 field in table A, let say field 1 ,field 2 and field 3 see whether got match the keywords or not.
table A
ID |field 1 | field 2 | field 3
----------------------------------------------------------------------------
1 |air conditioner |air conditioner,free| air conditioner
2 | chair | chair,furniture | chair,furniture
3 | hair | hair,human,body | hair,human,body
4 | dog | animal,dog | animal,dog
5 | cat | animal,cat | animal,cat
ok. let say i insert keywords such as --> " AIR,DOG,Animal " in the textbox and search it.
so based on the records from my table. it should query out the records : which ID = 1,4,5(Air Conditioner,Dog and cat)
it should not display the result for Chair OR hair even these two words combine with AIR tis word (Ch +Air) & (H +Air).
the record Cat will show out becoz in the field 2 the "Animal" keywords is matched. therefore it will show out.
so the final result it will display Air conditioner, dog and cat
do u all get wat i mean? 
i hope can get some response from u all soon. i need some help on coding.plz help.thanx alot.
p/s: i m using asp +MS SQL SERVER 2005
<message edited by kumiko on Wednesday, April 02, 2008 9:45 PM>
|
|
|
|
ebgreen
-
Total Posts
:
8227
- Scores: 98
-
Reward points
:
0
- Joined: 7/12/2005
-
Status: offline
|
RE: Problem in searching multiple keywords(database)
Thursday, April 03, 2008 1:38 AM
( permalink)
What is your code for the search right now?
|
|
|
|
kumiko
-
Total Posts
:
2
- Scores: 0
-
Reward points
:
0
- Joined: 4/2/2008
-
Status: offline
|
RE: Problem in searching multiple keywords(database)
Thursday, April 03, 2008 2:55 AM
( permalink)
<% %> above is my current searching code. plz help more.thank you i really need more help frm u alll..urgent..plz give me a hand..thank you
<message edited by kumiko on Monday, April 07, 2008 9:52 PM>
|
|
|
|