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 id_cat1=31 order by stt asc,id desc' at line 1syntax error: select * from table_product where hienthi=1 and id_cat=4 and id_item= and id_cat1=31 order by stt asc,id desc