public function get_by_ambulatory($amb) { $conn = $this->db->conn; try { $query = $conn->prepare("\n\t\t\t\t\t\t\t\t\t\tSELECT D.ID, D.FirstName , D.LastName , D.Curriculum, D.Birthday, D.Gender, D.Image\n\t\t\t\t\t\t\t\t\t\tFROM Ambulatories as A \n\t\t\t\t\t\t\t\t\t\tINNER JOIN AmbulatoriesDoctors as AD ON A.ID = AD.AmbulatoryID\n\t\t\t\t\t\t\t\t\t\tINNER JOIN Doctors as D ON AD.DoctorID = D.ID\n\t\t\t\t\t\t\t\t\t\tINNER JOIN Contents as C ON A.NameContentID = C.ID \n\t\t\t\t\t\t\t\t\t\tWHERE A.ID = ? AND C.Lang = ? AND D.Active = 1\n\t\t\t\t\t\t\t\t\t"); $query->execute(array($amb, $this->db->lang)); } catch (PDOException $e) { echo "Error: " . $e; } while ($row = $query->fetch(PDO::FETCH_ASSOC)) { $doctor = new Doctor($this->db); $doctor->update_class($row); array_push($this->doctors, $doctor); } }