| |
kumiko
Posts: 2
Score: 0
Joined: 4/2/2008
Status: offline
|
#1
 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 -- 4/2/2008 8:45:09 PM >
|
|
Printable Version
Problem in searching multiple keywords(database) - 
New Messages
No New Messages
Hot Topic w/ New Messages
Hot Topic w/o New Messages
Locked w/ New Messages
Locked w/o New Messages
Post New Thread