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 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 'and (CLIENT<>'거상코리아' || (client='거상코리아' and psellprice > 500' at line 1