You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND prod_onoff='yes' ORDER BY prod_sort DESC ,prod_sn DESC LIMI