public function loadNotifiers() { $id = $this->userid; try { $conn = Connector::getConn(); Client::loadIntoArray($this->category, $conn->query("SELECT * FROM category WHERE user_id = {$id}")->fetchAll()); Client::loadIntoArray($this->dailynots, $conn->query("SELECT t.*, c.name as category_name FROM task_daily t " . "INNER JOIN category c ON t.category_id = c.id WHERE t.user_id = {$id} ORDER BY category_name, id")->fetchAll()); Client::loadIntoArray($this->weeklynots, $conn->query("SELECT w.*, c.name as category_name FROM task_weekly w " . "INNER JOIN category c ON w.category_id = c.id WHERE w.user_id = {$id} ORDER BY category_name, id")->fetchAll()); Client::loadIntoArray($this->yearlynots, $conn->query("SELECT y.*, c.name as category_name FROM task_yearly y " . "INNER JOIN category c ON y.category_id = c.id WHERE y.user_id = {$id} ORDER BY category_name, id")->fetchAll()); } catch (Exception $e) { Client::log("Client > loadNotifiers() > Error : " . $e); } }