[PHP] Creating mySql search feature.....

Hi all, Need a little help here been at this for a while now... I have a database holding a table which in turn holds a collection of fields I need to search. Ive set up search form that sends the variable $S_For and $S_From, these variables represent the following: $S_For = the search

Re: [PHP] Creating mySql search feature.....

Hello, What you need is : 1- parse your query and make it boolean apple orange become apple and orange and so on 2- then you can generate a MySQL query based on that like this way --- SELECT id, field1 match (field1) against (' apple orange ') as relevance FROM hospitality WHERE

Re: [PHP] Creating mySql search feature.....

You first need to separate the words and then build your query: $words = explode(' ',$S_For); $cond=''; foreach($word as $str) { $cond .= $S_From LIKE '%$str%' AND ; // replace AND with OR if you want ANY word } // remove trailing AND(last 4 chars) or OR(last 3 chars) $cond = substr($cond,

Re: [PHP] Creating mySql search feature.....

Thank you Marek Marek Kilimajer [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... You first need to separate the words and then build your query: $words = explode(' ',$S_For); $cond=''; foreach($word as $str) { $cond .= $S_From LIKE '%$str%' AND ;