select * from ShopProduct where bigcate='$bigcate' and smcate='$smcate' and display = '1' and completion='1' and stock_amount>0 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