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 (giaban between 5000000 and 10000000) and id_xuatxu='68' order by stt,ngayta' at line 1syntax error: select * from table_product where hienthi=1 and type='product' and id_sub= and (giaban between 5000000 and 10000000) and id_xuatxu='68' order by stt,ngaytao desc limit 0,20