select("SELECT count(id) FROM `notification_list` WHERE `employee_id` = '$employee_id' AND `status` != '1'"); $notification_list = $db -> sql_query("SELECT nl.description,nt.link,nl.record_id,nl.employee_id,nl.generate_by_employee_id, DATE_FORMAT(`date_time`,'%M %d, %Y - %h:%m %p') as date_time FROM `notification_list` nl INNER JOIN notification_type nt ON nt.id = nl.`notification_type_id` WHERE nl.`employee_id` = '$employee_id' AND nl.status = 0 ORDER BY nl.date_time DESC LIMIT 5"); ?>