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<>'거상코리아' or (client='거상코리아' and incomeWonPrice >= 5000 and incomeWonPrice <= 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