Keywords as a search criteria

[ping]

Hello
How can I add the keywords in the search?
I mean like the search understand the arfoo_keywordsofsites as a normal field (ie: description), and use with the rest of the criterias

the line is from models/SiteModel.php, but I need some help to modify the rest (there's no siteKeywords field since its from another table and I also think that a IF is needed)

$c->add("MATCH (siteTitle, description)

if thats not possible, there's another solution like a "keyword search" or "keyword filter"?

thank you

[chadon]

I am sorry not to be able to help for this but from what I saw, you are not the only one to complain about the performance of the search engine so hopefully, this will be improved in a future version.

Edit: Arf explained how to add an extra field to the search engine in the French board. Maybe this will do what you want.
You can take a look at the code here:
http://forum.arfooo.com/post5232.html
and if you need the instructions to be translated, let me know.

[ping]

sure i already did that, but it really sucks that this feature is not available
but ok, i'm going to try to make a keyword filter by myself

[ping]

I can make the script if somebody help me to translate this to a mysql query:
you only need to look at the bold part, because i can do the rest

- user enter the $search or whatever you want to name the $
- if $search = arfooo_keywords.keyword, get the keywordID from the same line
- switch to table arfooo_keywordofsites.keywordID and list all the siteID that uses that keywordID
- list all the matches and transform siteID on the site name

ps: i think it will use something like (from the arfooo_keywords.keyword)

WHERE keyword LIKE '%$search%'

[chadon]

I can probably get some help in the French forum but before I do so I have a question. Would this code search for links depending of their title/description content AND keywords or would you have two options to search for the links content OR keywords?
If it's the second, I can probably write something much more easy to implement.

[chadon]

Never mind my last question, my idea won't work.
I will ask for help in the other forum.

[ping]

i think its not "that" complicated
all we need is a person that know how to make a proper query, with INNER JOIN, LEFT or whatever is needed
too bad I cant, i event tryed but no sucess

[chadon]

[ping]

[chadon]

Glad we could help and thanks for your correction sent in the two forums

[skdo84]

[seopositive]

A type of search that looks for matching documents that contain one or more words specified by the user.

[hosting456]

Hi,

You will find that it is very difficult to achieve higher search engine ranking, without geniue quality content.

Nevertheless, you may find the following information useful, about meta tags, which can be used to provide search engines with additional keywords: http://www.brugbart.com/?AID=81

The best way to get higher search engine ranking, is to make sure high-quality relevant pages link back to you. Also make sure that your keywords actualley apear somewhere in your content, and you don't duplicate content.

You may also wan't to create a sitemap, see http://www.sitemap.org/ for more information. This step won't make sure your pages apear, but it dose make sure search engines know about all your pages.

[erslageorge]

Keywords are terms and phrases, including a combination of letters, numbers, and special characters on which you can base your search. When creating document search criteria, you can use a combination of keywords, operators, wildcard characters, and grouping to define your query. Try to be as spWhen creating document search criteria, you can use a combination of keywords, operators, wildcard characters, and grouping to define your query. Try to be as specific as possible when coming up with search criteria.

______________

[disolmodo78]

I think it is "that" complicates everything we need is someone who knows how to do proper consultation with INNER JOIN, LEFT or whatever it takes a shame I can not, I tried to events, but without success.