Tam
|
| Posted: 07/26/2005, 8:48 AM |
|
Hi there,
Here is my scenario: I have an record with title having a word
Push/Pull
. As I search EITHER for push or pull, the record appear. However, as I put both word
push pull
(with a blank space between them which usually happened) in the search textbox, the record is not shown.
If there is a way to make it work, please suggest. Thanks.
|
|
|
 |
Nicole
Posts: 586
|
| Posted: 07/27/2005, 4:56 AM |
|
Tam,
It is normal. Because "push pull" substring doesn’t match a part of search pattern "Push/Pull". You can test the same query against the database and get the same results. You need to use ‘All Words’ search to return a record for 2 (or more) entered words.
To implement it you can catch parameter string and split it into separate words using PHP functions. Then build WHERE on a fly adding new WHERE condition for every word.
_________________
Regards,
Nicole |
 |
|
|
