Dear All,
Let me further describe my question:

The Fields which were (weight:2) indexed:
Title:
URL:
Description:

One of the Links Example:
Title: Yahoo
URL: http://www.yahoo.com/
Description: Search Engine

How can modify the script in order to let people find this link more "accurately" by using "AND"?
e.g. Search "Yahoo Search Engine" as keywords

Because, the current LinksSQL seems cannot support "AND", the links come "OR".


I also tried some famous LinksSQL sites, like pugdog's http://www.Postcards.com.

When I search "Free Postcards.com" by using "AND", it is logically predicted that the result is only postcards.com, however, the result seems is "OR" result!
you can try this
http://www.postcards.com/...=and&substring=1

The only way around this at the moment is to use the "advanced" features of the search with +/-.

+yahoo +search +engine will find _only_ "yahoo search engine" in the results.

You need to make up a bit of a "help" on how to use the +/- on the words to get an "and" search.

Nothing else seems to work, and the fix the last time I looked was complicated and multi-file, since passed parameters are ignored for some reason as well.



http://www.postcards.com
FAQ: http://www.postcards.com/FAQ/LinkSQL/

Oops... My version don't have "Advanced" feature as you said....

What version should have "Advanced"? Also difficult to upgrade?

The "advanced" is just a template thing. Depending on what templates you use. You can use the +/- at any search box, but usually you put the explanation on the "search" page (what you get if you run search.cgi without any arguments).

http://www.postcards.com
FAQ: http://www.postcards.com/FAQ/LinkSQL/

OK, Thx Pugdog.
Now accompanied with LinksSQL were 2 search scripts:
1. search.cgi
2. search-ori.cgi

They work as two routines.

The first one is for searching "part of the words", i.e. "Yah" is matched with "Yahoo" in result, but not compatible with +/-; ALSO ***Not function under "AND"***

The Second one is compatible with +/-, but only "Yahoo" matches "Yahoo" in searching.

Pugdog, do you think combining these two "Points" is good?
Currently, any modification improving the searching?