multiple words in search field

[v3nt]

i've got this query that searches a number of fields and returns the results. but how can i get it to consider other words in the query?

thanks.

$quicksearch="garden bt4"; 

// i want it to pick up garden from pbrief, and bt4 from the ppostcode row..

$searcher ="(pg5 like '%$quicksearch%' OR pprice like '%$quicksearch%' OR pprice like '%$quicksearch%' OR paddress1 like '%$quicksearch%' OR paddress2 like '%$quicksearch%' OR ppostcode like '%$quicksearch%' OR pbrief like '%$quicksearch%' ) 
";

$query_PD = "SELECT * FROM property WHERE pavailable ='1' AND synchDel !='1'
AND $searcher
ORDER BY $ordercrit LIMIT $thread_list_offset, $threads_per_page";

[jdwmk]

Hi,

$quicksearch in this example is effectively an array, you will need to do something like

$qsArr = explode(" ", $quicksearch);

this will then make 'garden' and 'bt4' available under $qsArr as $qsArr[0] and $qsArr[1].

You can therefore do

$searcher ="(pg5 like '%$quicksearch%' OR pprice like '%$quicksearch%' OR pprice like '%$quicksearch%' OR paddress1 like '%$quicksearch%' OR paddress2 like '%$quicksearch%' OR ppostcode like '%$qsArr[1]%' OR pbrief like '%$qsArr[0]%' )
";

I hope this helps. Of course you will find that if you add additional words in there, you will need to expand on this, but that should be the general gist of what you need.

Jeff