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 RAND() limit 8' at line 1syntax error: select id,photo,ten_vi,giaban,giacu,noibat2,tenkhongdau,ngaytao,thongtin_vi,masp from table_product where hienthi=1 and type='product' and id_cat='' and id<>  order by RAND() limit 8