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,id desc' at line 1syntax error: select id,id_danhmuc,ten,tenkhongdau,thumb,photo,gia,maso,nhasanxuat,thumb2,thumb1,spconhang,spkhuyenmai,giakm,mota,spsale,size,mau,sphethang,spmoi from table_product where hienthi=1 and id_danhmuc=  order by stt,id desc