A PHP Error was encountered
Severity: Warning
Message: Cannot modify header information - headers already sent by (output started at /home/rsmmc/system/core/Exceptions.php:272)
Filename: core/Common.php
Line Number: 565
Backtrace:
File: /home/rsmmc/application/models/Doctor_model.php
Line: 106
Function: query
File: /home/rsmmc/application/views/doctor/doctordetails.php
Line: 15
Function: Get_SchedDoctor
File: /home/rsmmc/application/controllers/Doctor.php
Line: 100
Function: view
File: /home/rsmmc/public_html/index.php
Line: 315
Function: require_once
A Database Error Occurred
Error Number: 1064
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 ds.is_nonaktif IS not true and ds.empid = metrohealth' at line 17
SELECT d.fullname,d.empid,ds.did,dp.name_formal, ds.`weekday`, case when ds.weekday = 1 THEN 'Senin' WHEN ds.weekday = 2 THEN 'Selasa' WHEN ds.weekday = 3 THEN 'Rabu' WHEN ds.weekday = 4 THEN 'Kamis' WHEN ds.weekday = 5 THEN 'Jumat' WHEN ds.weekday = 6 THEN 'Sabtu' ELSE 'Minggu' END AS days, ds.start_hour,ds.end_hour,case when ds.start_minute < 1 THEN '00' ELSE ds.start_minute END AS mulai, case when ds.end_minute < 1 THEN '00' ELSE ds.end_minute END AS selesai FROM doctor_schedule_hysis ds JOIN new_doctor d ON d.empid=ds.empid JOIN tbl_department dp ON dp.did=ds.did WHERE ds.did = AND ds.is_nonaktif IS not true and ds.empid = metrohealth
Filename: models/Doctor_model.php
Line Number: 106