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 'order by stt,id asc' at line 1syntax error: select ten_vi as ten,id,tenkhongdau,photo from table_product_item where hienthi=1 and type ='product' and id_cat= order by stt,id asc