Here my value inserted in to the table is like as follows,
`2017-01-01`,
`2017-01-02`,
`2017-01-03`,
`2017-01-04`,
`2017-01-05`,
`2017-01-06`.
i need to fetch only year and month from that, for that i used my code like this
public function present_report_by_empid($user_id = null,$date = null)
{
$query='tbl_attendance.date_in';
$this->db->where('tbl_attendance.attendance_status', 1);
$this->db->where('tbl_attendance.user_id', $user_id);
$this->db->where(date('Y-m',strtotime($query)), $date);
return $this->db->count_all_results('tbl_attendance');
}
My $date value is 2017-01
and when i gave like this am getting error like this
SELECT COUNT(*) AS
numrowsFROM
tbl_attendanceWHERE
tbl_attendance.
attendance_status= 1 AND
tbl_attendance.
user_id= '1' AND
1970-01= '2017-01'