Having problem to match the search result with search query

Hello

I am having a big problem to match the search query with search result. It seems that the result showing is not in correct order. The example is as below;

My search query is "Juairiyah bint al-Harith" without the quote and when I get the result then the first result is coming with the word "al-Harith" while the full match should come at the first and then gradually the partial match result will come at the end. I could not figure it out what is the cause of this problem. When I make exact match then it works but in normal search the result mismatch. Pls help me to figure out the problem.

I am passing the ftp info in private.

Our search extension doesn't do a dynamic ORDER BY based on search results. You could add one manually to put an exact match first specifically, but qualifying and rating results to determine their priority would get complicated. If you give me FTP access and tell me the page in question then I'll add the ORDER BY statement to prioritize exact matches.

This post has been deleted.

Originally Said By: Ray Borduin

  Our search extension doesn't do a dynamic ORDER BY based on search results. You could add one manually to put an exact match first specifically, but qualifying and rating results to determine their priority would get complicated. If you give me FTP access and tell me the page in question then I'll add the ORDER BY statement to prioritize exact matches.  

Dear Ray

I am providing the ftp info and page url herewith in private.

When I edit that page with the FTP it doesn't seem to effect the page.

I think you can just add something like:

if (isset($_GET["q"])) {

    $SearchPage->Statement .= " ORDER BY INSTR(BanglaHadith,".$SearchPage->getSQLValue($_GET["q"],"s") .")>0 DESC, INSTR(EnglishHadith,".$SearchPage->getSQLValue($_GET["q"],"s") .")>0 DESC, INSTR(ChapterEN,".$SearchPage->getSQLValue($_GET["q"],"s") .")>0 DESC, INSTR(HadithNote,".$SearchPage->getSQLValue($_GET["q"],"s") .")>0 DESC, INSTR(ChapterBG,".$SearchPage->getSQLValue($_GET["q"],"s") .")>0 DESC, INSTR(explanation,".$SearchPage->getSQLValue($_GET["q"],"s") .")>0 DESC, INSTR(ArabicHadith,".$SearchPage->getSQLValue($_GET["q"],"s") .")>0 DESC, INSTR(ArabicHadithNew,".$SearchPage->getSQLValue($_GET["q"],"s") .")>0 DESC, INSTR(ChapterAR,".$SearchPage->getSQLValue($_GET["q"],"s") .")>0 DESC";

}

on the line before:

$SearchPage->execute();

Originally Said By: Ray Borduin

  When I edit that page with the FTP it doesn't seem to effect the page.

I think you can just add something like:

php:

if (isset($_GET["q"])) {

    $SearchPage->Statement .= " ORDER BY INSTR(BanglaHadith,".$SearchPage->getSQLValue($_GET["q"],"s") .")>0 DESC, INSTR(EnglishHadith,".$SearchPage->getSQLValue($_GET["q"],"s") .")>0 DESC, INSTR(ChapterEN,".$SearchPage->getSQLValue($_GET["q"],"s") .")>0 DESC, INSTR(HadithNote,".$SearchPage->getSQLValue($_GET["q"],"s") .")>0 DESC, INSTR(ChapterBG,".$SearchPage->getSQLValue($_GET["q"],"s") .")>0 DESC, INSTR(explanation,".$SearchPage->getSQLValue($_GET["q"],"s") .")>0 DESC, INSTR(ArabicHadith,".$SearchPage->getSQLValue($_GET["q"],"s") .")>0 DESC, INSTR(ArabicHadithNew,".$SearchPage->getSQLValue($_GET["q"],"s") .")>0 DESC, INSTR(ChapterAR,".$SearchPage->getSQLValue($_GET["q"],"s") .")>0 DESC";

}

on the line before:

php:

$SearchPage->execute();

  

Dear Ray

Thanks for your great support!

Meanwhile I did a little change on the generated code to another page and it brings the result what I was looking for.

I just change "and"=>" ", "or"=>", " instate of "and"=>", ", "or"=>" " and the problem is solved and it is giving me perfect result every time.