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 city_id!='125'' at line 1. SQL: select count(city_id) from ht_city a where city_isview = 1 and region_id = and city_id!='125'