▽1
●
jirepo ベストアンサー |
キーワードを分解するロジックまでは確認していませんが、
$where = " WHERE (jyusyo Like \"%$arykey[0]%\")OR (comment Like \"%$arykey[0]%\")OR (sale Like \"%$arykey[0]%\")OR (setubi Like \"%$arykey[0]%\")OR (kouzou Like \"%$arykey[0]%\")OR (sikiti Like \"%$arykey[0]%\")OR (moyorieki Like \"%$arykey[0]%\")OR (madori Like \"%$arykey[0]%\")";
を
$where = " WHERE ( (jyusyo Like \"%$arykey[0]%\")OR (comment Like \"%$arykey[0]%\")OR (sale Like \"%$arykey[0]%\")OR (setubi Like \"%$arykey[0]%\")OR (kouzou Like \"%$arykey[0]%\")OR (sikiti Like \"%$arykey[0]%\")OR (moyorieki Like \"%$arykey[0]%\")OR (madori Like \"%$arykey[0]%\") )";
というように、&tmpkeyでつなぐキーワード全体をもうひとつの()でくくらないと
and検索にならないとおもいます。