Originally Posted by tical

put the OR parts in parenthesis, i think that should fix it

$trysrch = @mysql_query("select * from table_name where (item_name like '$srch' || item_name2 like '$srch' || item_name3 like '$srch') && area = '$place' order by item_name asc");