select * from ShopProduct where (pname like '%$search%' or eng_pname like '%$search%' or pro_title like '%$search%') and display = '1' order by $orname $orsun You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '$orsun' at line 1