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 'order by stt asc limit 0,16' at line 1syntax error: select * from table_product where hienthi=1 and id_parent='1' order by stt desc order by stt asc limit 0,16