select * from ShopProduct where bigcate ='$bigcate' and smcate = '$smcate' 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