kiran_n444
New Member
I have a select where like query for a seach form which is as follows:\[code\]<?php $bucketsearch = sanitizeone($_POST["bucketsearch"], "plain");$bucketsearch = strip_word_html($bucketsearch);?> if(isset($_POST['search'])){ $result=MYSQL_QUERY( "SELECT * FROM buckets where bucketname like '%$bucketsearch%' order by bucketname"); }else{ $result=MYSQL_QUERY( "SELECT * FROM buckets order by bucketname"); }\[/code\]My problem is that if someone searches for instance for "apple and pear" i do not get any results that contain any of the words, i can only make it return results (well 1 result) with all the words in it. Can anyone help me make this search a bit more versitle?? Thanks in advance.