select * from Property where RecycleBin=0 and Active=1 and CategoryID='10' and PropertyFor like '%Sale%' and CountryID='1' and RegionID>=1 and and Price>='0' and Price<='999999999' and BedroomsNo>='1' and BedroomsNo<='99' and SurfaceArea>='100' and SurfaceArea<='500' and Compound>=0 and PriceDay>=0 order by ID DESC LIMIT 0,10
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 Price>='0' and Price<='999999999' and BedroomsNo>='1' and BedroomsNo<='99' a' at line 1

Select All