Improving the performance of the basic internal search tool

[afroken]

Hi there,

We've just bought eSyndicat script and its all going ok so far.

But we've hit a small problem with the internal search engine. We are using the directory script to browse and search company listings and each company listing in the directory has the usual fields: -

• company name
• address
• web address
• email /tel number
• etc, etc

So when I tested the search by searching for the only companies with a certain town/country name, the search script came up short with no results.

Tried it with a few more and got the same results.

It was only when using the advanced search tool that I could then find the listings I was looking form.

My question is this:
Is there a way to get basic search to find these listings as advanced search does but by making the address, description postcode etc etc fields default for the script to keyword match?

Any help would be great!

[tyronepinnoy]

Originally Posted by afroken

Hi there,

We've just bought eSyndicat script and its all going ok so far.

But we've hit a small problem with the internal search engine. We are using the directory script to browse and search company listings and each company listing in the directory has the usual fields: -

• company name
• address
• web address
• email /tel number
• etc, etc

So when I tested the search by searching for the only companies with a certain town/country name, the search script came up short with no results.

Tried it with a few more and got the same results.

It was only when using the advanced search tool that I could then find the listings I was looking form.

My question is this:
Is there a way to get basic search to find these listings as advanced search does but by making the address, description postcode etc etc fields default for the script to keyword match?

Any help would be great!

hi, have you had any joy with this request ?

[Alex B.]

Hello!
Welcome to our support forums!
The basic search is browsing only within titles, urls, and descriptions.
If you want to add some fields you should edit the file includes/classes/esynListing.php

Find the function searchCriterias
[ Find this code inside the function ]

PHP Code:

$tmp[] = "(CONCAT(`t1`.`url`,' ',`t1`.`title`,' ',`t1`.`description`) LIKE '%{$word}%')"; 


and

PHP Code:

$sql .= "WHERE (CONCAT(`t1`.`url`,' ',`t1`.`title`,' ',`t1`.`description`) LIKE '%{$aWhat}%')"; 


[ After `description` add this code ]

PHP Code:

,' ',`t1`.`name_of_the_field` 


where «name_of_the_field» is the field name you want to browse too.
You may add a few fields at once:
[ After `description add this code ]

PHP Code:

,' ',`t1`.`name_of_the_field1`,' ',`t1`.`name_of_the_field2`,' ',`t1`.`name_of_the_field3` ..............