select("SELECT count(id) FROM `notification_list` WHERE `employee_id` = '$employee_id' AND `status` != '1'"); $notification_total_count = Database::connect()->selectBaseQuery("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"); $notification_list = Database::connect()->runBaseQuery("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"); ?>