public static function getGoalById($goid) { $stmt = Database::getDB()->prepare("\r\n\t\t\tSELECT *\r\n\t\t\tFROM goals\r\n\t\t\tWHERE\r\n\t\t\t\tgo_id = ?\r\n\t\t"); $stmt->bind_param("i", $goid); $stmt->execute() or die($stmt->error); $stmt->store_result(); $goal = new Goal($stmt->fetch_assoc()); $stmt->close(); $goal->metadata = $goal->getMetadataForGoal(); //$goal->updatePercent(); return $goal; }