Search words

[RON_ron]

I'm trying to pull in data using a particular word from a mysql db (it's like a search facility).

 

But this code only picks if the db has got the exact same word.

E.g. if fincom = "DALLS" it pulls the data only when "searchwords" has DALLS. It ignores if "searchwords" has BARBIE DALLS. How can I fix this. I need to pick all records which contains the search word 'fincom' anywhere in  searchwords.

 

Hope this makes scene.

 

$SomeVar = $_POST['fincom'];

$query = "SELECT * FROM  news_home WHERE searchwords = '".$SomeVar."' ORDER BY timestamp DESC";

$results = mysql_query($query);

[RON_ron]

am I in the wrong place?

[litebearer]

Look here...

http://www.brainbell.com/tutorials/MySQL/Using_The_LIKE_Operator.htm

[RON_ron]

Thanks. This is my new code. Still I can not find BARBIE DOLLS (all records which is similar to $SomeVar). Any idea whats wrong here?

 

$SomeVar = $_POST['fincom'];
$query = "SELECT * FROM news_home WHERE searchwords LIKE '%".$SomeVar."%' ORDER BY timestamp DESC";
$results = mysql_query($query);

$returnS="";
while($line= mysql_fetch_array($results))
{
$returnS.= $line["subject"].",,".$line["timestamp"].",,".$line["News"].",,".$line["links"].",,,";
}

[AbraCadaver]

Probably a better way using fulltext searches or something, but this will work:

 

$like  = "searchwords LIKE '%".implode("%' OR searchwords LIKE '%", explode(' ', $SomeVar))."%'";
$query = "SELECT * FROM news_home WHERE $like ORDER BY timestamp DESC";

[RON_ron]

That's Awesome!! Thanks  AbraCadaver!