MySQL Query:SELECT COUNT(houseid) AS number FROM h_house WHERE  infocat=4 and name = '´óÌÆÊÀ¼ÒÐÜèÊû'  and propertytype=1 and (price<=150 or (unit=3 and price*buildarea <=150*10000)) and buildarea>150 and buildarea<lou1= and currentfloor<13 and decorate=5 <br> MySQL Error: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 currentfloor<13 and decorate=5' at line 1 <br> MySQL Errno:1064 <br> Message:MySQL Query Error