order results by relevancy

[deiv82]

Hello everybody, I'm trying to find a way to order by relevancy the result of my simple search engine...
I've found on the web different solutions, but I'm not able to adapt them to my case.

$querystr = "SELECT img,link,numclick,description,order FROM table1 WHERE 1=1 ";
 
            for ($x = 0; $x < count($keys); $x++) {
               $querystr .= "and concat( description, order ) like \"%$keys[$x]%\"";
            }
 
            $querystr .= " limit 20";
 

Some advices?
Many thanks

[code green]

What do you see as relevancy?

[deiv82]

At the moment I get the results in the order by how they are in the database and not by the most similarity of the word searched...
I've tried using MATCH and AGAINST but I don't know how to use it in my code and also no idea if it's useful for my case.

If not I found also this solution it seemed to be good but I can't make it work ...

$querystr = "SELECT 
( if ( instr( title , $keys[0] ) > 0 , 3 , 0 )
 
+ if ( instr( title , $keys[1] ) > 0 , 3 , 0 )
 
+ if ( instr( title , $keys[2] ) > 0 , 3 , 0 )
 
+ if ( instr( description, $keys[0]) ‘ ) > 0 , 1 , 0 )
 
+ if ( instr( description, $keys[1]) ‘ ) > 0 , 1 , 0 )
 
+ if ( instr( description, $keys[2]) ‘ ) > 0 , 1 , 0 )
 
) as relevance ,
 
img,
link,
numclick,
description,
title 
 
FROM MyTable 
 
WHERE 
 
concat_ws(‘ ‘ , title , description) like ‘%$keys[0]%’
 
and concat_ws(‘ ‘ , title , description) like ‘%$keys[1]%’
 
and concat_ws(‘ ‘ , title , description) like ‘%$keys[2]%’";
 
            for ($x = 0; $x < count($keys); $x++) {
               $querystr .= "and concat( description, title ) like \"%$keys[$x]%\"";
            }
            $querystr .= " ORDER BY relevance DESC LIMIT 20";
 

[code green]

This thread seems suspiciously similar to this one
http://bytes.com/topic/mysql/answers...e-record-below
Is it assignment time again

[Oralloy]

@code_green,

Your link doesn't work.

What I see is

http://how%20to%20return%20the%20record%20above%20and%20the%20record%20below/

Will you please fix it?

[deiv82]

I have not understood what is the problem...?