public function get_my_vaccinations() { global $database; $sql = "SELECT `v`.* FROM `pet` AS `p` "; $sql .= "INNER JOIN `pet_to_vaccination` AS `pv` ON `pv`.`pet_wk` = `p`.`pet_wk` "; $sql .= "INNER JOIN `vaccination` AS `v` ON `v`.`vaccination_wk` = `pv`.`vaccination_wk` "; $sql .= "WHERE `p`.`pet_wk` = " . $this->pet_wk . " "; $sql .= "ORDER BY `v`.`vaccination_name` ASC;"; //get the resultset $this->vaccination = Vaccination::find_by_sql($sql); }