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' at line 1syntax error: select * from table_product_item where hienthi=1 and tenkhongdau='xe-ben-suzuki' and id_list=1 and id_cat= order by stt asc