Faculty Member


SELECT lecturer_all.name as fac_name, post, research_inter, contact, placed, rank, building, office, position, home_page, short_descr, sname, title, department.name as d_name FROM lecturer_all INNER JOIN department ON lecturer_all.site_dept = department.did WHERE lcid = And lecturer_all.active = 1 had this 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 lecturer_all.active = 1' at line 1