SQL

An Error has occured, please contact the system administrator.

---

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 city' at line 1
Query:
SELECT city, samajid, title, entry_date, description, street_name, province, zip_code, unit_no, phone1, fax, email, contact_name1, contact_phone11, contact_email1 FROM samaj where is_active = '1' and is_temple = order by city