Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/brotherfishing/libr/DatabaseLib.php on line 22
select * from ShopProduct where ( or (REPLACE(pname, ' ', '') LIKE '%%')) or (pcompany like '%%') or (client like '%%') AND (CLIENT<>'거상코리아' || (client='거상코리아' and psellprice > 5000 and psellprice < 2000000)) order by CASE WHEN amount = 0 THEN 1 ELSE 0 END ASC, updatetime desc
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 'or (REPLACE(pname, ' ', '') LIKE '%%')) or (pcompany like '%%') or (client like' at line 1