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 _employees.isEnabled = 'Y' ORDER BY EmpName ASC' at line 1
SELECT EmpID, EmpName, JobEndDate FROM sci._employees LEFT JOIN sci._positions ON _positions.PositionCode= _employees.PositionCode LEFT JOIN sci._sections ON _sections.SectionId = _positions.SectionId WHERE _sections.DepartId = AND _employees.isEnabled = 'Y' ORDER BY EmpName ASC[phpBB Debug] PHP Warning: in file [ROOT]/sci/include/db.php on line 46: mysql_num_rows() expects parameter 1 to be resource, boolean given
[phpBB Debug] PHP Warning: in file [ROOT]/sci/include/db.php on line 47: mysql_num_fields() expects parameter 1 to be resource, boolean given
[phpBB Debug] PHP Warning: in file [ROOT]/sci/include/db.php on line 63: mysql_fetch_array() expects parameter 1 to be resource, boolean given
SCI CORPORATION CO., LTD. • Check Asset