How could be this search type ?!

[Richi]

hi ..

i need to search i the db by word, let say if i have in the db with words : 'This nice cat.' , i need to find this if i type in the search box : 'this is cat' , or 'cat is nice' .

also if i have ' SitePoint.com ' how can do this to find it if i type : 'site*' ?


how ????

[Richi]

found it, i need mysql 4 to do that

but any way FULLTEXT didn`t work with me any1 know whay ?

i have title and des so :

MATCH (title,des) AGAINST ('$keyword')

and with mysql i change the tabels :
[php]

ALTER TABLE house ADD FULLTEXT (title,des)
ALTER TABLE house ADD FULLTEXT (des,title)

[php]

but cann`t find any with search ? whay ??

[notepad_coder]

Have you tried something like this?

$s = mysql_query("SELECT * FROM table WHERE words LIKE '%$search%' ORDER BY words ASC"); 

I'm not really sure, bu I think thats what you use in a search script.

[Richi]

$s = mysql_query("SELECT * FROM table WHERE words LIKE '%$search%' ORDER BY words ASC");

this what am using, but as i said if u have :
' this is cat '

and u search this cat , with u way will not find it, but with fulltext u will find it !!

any any1 know what the wong with this query, i got no error and no result

    $query= mysql_query("select * from house  where MATCH (title,des) AGAINST ('$keyword') "); 

Keyname  Type      Cardinality  Field 
title    FULLTEXT  None         title  
                                des   1

??

[notepad_coder]

I did a test with this and it worked fine.

$s = mysql_query("SELECT * FROM test WHERE words LIKE '%$search%' ORDER BY words");
while ($r = mysql_fetch_object($s)) {
  echo $r->words. "<br>";
} 

It let my search for multiple words at a time.

[Richi]

there are some mistake here, shouldn`t work with, fust fulltext can search with this way !

[notepad_coder]

But you shouldn't have to change stuff to fulltext just so you can search though them. using

something LIKE '%$search%' 

will search hrough anything.

[Richi]

Grrrrrrrrr ........
dumb manual ...

that whay didn`t work with me :

Tim Gustafson: Note: you should add at least 3 rows to the table before you try to match anything, and what you're searching for should only be contained in one of the three rows. This is because of the 50% thereshold. If you insert only one row, then now matter what you search for, it is in 50% or more of the rows in the table, and therefore disregarded.

it was at the end of the manual, as comments ...

now, he user type one word i`ll use Like '%cc%' if more the full text mode ..


thx ..

[notepad_coder]

I'm not sure how well this works but you could try this and search for "some to search for" or something for" and it would print everything containing those words even if they arn't exactly the same.

<?
if ($_POST) {
    $words = explode(" ", $_POST['search']);
    for ($i = 0; $i <= sizeof($words)-1; $i++) {
        if ($i == 0) {
            $where = "WHERE words LIKE '%$words[0]%' ";
        } else {
            $where .= " AND words LIKE '%$words[$i]%'";
        }
    }
    $s = mysql_query ("SELECT * FROM table " .$where. " ORDER BY words ASC");
    while ($r = mysql_fetch_object($s)) {
        echo $r->words. "<br>";
    }
}
?>

What it does is puts all the search words into an array and then finds matches for all those words in the table.

[Richi]

here is my way ...

    if($keyword){
        // remove the space from the beginning //
        $keyword = ltrim($keyword);    
        // also from the end //
        $keyword = rtrim($keyword);    
    }        
    if($keyword != "" And substr_count("$keyword"," ") >=1){ // More than 1 word            
            $By_Like = " And MATCH (title,des) AGAINST ('$keyword')";
            $Match_Word =1;
            //echo "many";
            }
    elseif($keyword != "" And substr_count("$keyword"," ") < 1){ // then just 1 word
        $By_Like = "  And( title like '%$keyword%'  OR   des like '%$keyword%') ";
        $Match_Word =0;
        //echo " 1 word ";
    }


///


    $query= mysql_query("select *  from house where
     active='yes' And 
     country ='$Country' 
     $By_City 
     $By_Cat  And
     ($s_type)  $By_Like
     ");


///



        if($By_Like And $Match_Word=0){
            $des = ereg_replace("$keyword","<font color=#FF0000>$keyword</font>",$des);
        }
        elseif($By_Like And $Match_Word=1){
            $This_des = explode(' ', $keyword);
                        
            foreach ($This_des as $xdes){
                if($xdes !=""){
                    
                    $des = ereg_replace("$xdes","<font color=#FF0000>$xdes</font>",$des);
                }
            }
        } 

and it`s work as need ..